BUG: Error Message 823 or Retail Assert Encountered During Restore of SQL Server Log Backup (281809)

The information in this article applies to:

Microsoft SQL Server 7.0

This article was previously published under Q281809

BUG #: 101046 (SQLBUG_70)

SYMPTOMS

After a log restore, SQL Server may encounter either error message 823 or the following retail assertion during the recovery phase:

Server: Msg 823, Level 24, State 1, Line 2 I/O error (bad page ID) detected during read of BUF pointer = 0x14210e40, page ptr = 0x1f952000, pageid = (0x1:0xe1a), dbid = 8, status = 0x801, file = C:\MSSQL7\data\dbTest.mdf.

-or-

pageref.cpp:3889 expression: ppage > getlsn == lp > getprvpagelsn "

CAUSE

SQL Server may allow the log to be backed up when non-logged operations have taken place.

WORKAROUND

To workaround this problem either:

Avoid the use of non-logged operations.

-or-
Ensure that any process performing non-logged operations complete and secure a complete database backup.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.

MORE INFORMATION

To encounter this issue:

A production database must have SELECT INTO/BULK COPY enabled during a bcp operation.
Do not provide a table lock hint to the bcp operation.
Use a large enough bcp operation to allow bcp to escalate to a table lock.

Modification Type:	Major	Last Reviewed:	10/16/2002
Keywords:	kbBug kbDSupport KB281809