Microsoft KB Archive/281809

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

Article ID: 281809

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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 &quot;



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.

Keywords: kbbug kbpending KB281809

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.