Article ID: 295644 - View products that this article applies to.
This article was previously published under Q295644
BUG #: 352799 (SHILOH_BUGS)
Transaction log restores may fail with a 3456 error message when minimally logged operations (bcp, SELECT INTO, and so forth) are performed on the server. The error message text is similar to the following:
Redo of log record 00000018:00000036:0001 for transaction 0000:000027c2 failed on page %S_PGID for database Northwind. Page: LSN = %S_LSN, type = %ld. Log: OpCode = %ld, context %ld, PrevPageLSN: %S_LSN.
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
HotfixNOTE: The following hotfix was created prior to Microsoft SQL Server 2000 Service Pack 1.
The English version of this fix should have the following file attributes or later:
NOTE: Due to file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.
Version File name ------------------------ 8.00.0269 s80269i.exe
To avoid this problem, use a full recovery model on the database.
To change the recovery model, use these steps:
-or-To change the recovery model from the SQL Server Query Analyzer by using Transact-SQL, run the following command:
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 1.