Message 3738 could not redo log

[jimmYLepp]

I have a SQL Server 2000 sp 3a server and recieved this error on a transaction log restore. Any ideas on what caused this?



Executed as user: USTRESCHIRES1\SQLDBADMIN. Processed 30488 pages for
database 'dlsn1_tilt', file 'TILT_Log' on file 1. [SQLSTATE 01000]
(Message 4035) Deleting database file
'D:\MSSQL\Backup\from_dlsn1\tilt\undo_tilt_tl.ldf'. [SQLSTATE 01000] (Message 3738) Could not redo log
record (231394:5256:84), for transaction ID (0:348175768), on page
(1:266904), database 'dlsn1_tilt' (19). Page: LSN = (231380:6308:51), type =
11. Log: OpCode = 4, context 11, PrevPageLSN: (231382:10193:5). [SQLSTATE
42000] (Error 3456). The step failed.


Later jimmY

 

[jimmYLepp]

Found the solution here.

http://support.microsoft.com/default.aspx?scid=kb;en-us;329487

Later jimmY