FIX: Transaction Log Restores May Fail with 3456 Error
This article has been archived. It is offered "as is" and will no longer be updated.
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 theMicrosoft Knowledge Base:
290211 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:
Version File name ------------------------ 8.00.0269 s80269i.exeNOTE: Due to file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.
To avoid this problem, use a full recovery model on the database.
To change the recovery model, use these steps:
- Open Enterprise Manager.
- In Enterprise Manager, click to select a database name. Click Properties, and then click Options.
- In the Options dialog box, select Full for the recovery model.
-or-To change the recovery model from the SQL Server Query Analyzer by using Transact-SQL, run the following command:
ALTER DATABASE <DBNAME> SET RECOVERY FULL
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.
Article ID: 295644 - Last Review: 01/16/2015 22:24:02 - Revision: 4.0
Microsoft SQL Server 2000 Standard Edition
- kbnosurvey kbarchive kbbug kbfix kbqfe kbsqlserv2000sp1fix KB295644