restore error

[jeffinperth]

Hi All
environment:
mssqlserver 2000 sp1
Microsoft SQL Server 2000 - 8.00.384 (Intel X86) May 23 2001 00:02:52 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

attempting a restore of our prod database to to another database using the command

restore database testebocontrol from disk = 'b:\SQL\ebocontroldbthursday.bak'
with move 'eBOControl_Data' to 'c:\testebocontrol.mdf',
move 'eBOControl_Log' to 'c:\testeobcontrol.ldf'

we get the error

<snip>
Processed 840 pages for database 'testebocontrol', file 'eBOControl_Data' on file 1.
Processed 1 pages for database 'testebocontrol', file 'eBOControl_Log' on file 1.
Server: Msg 3448, Level 21, State 1, Line 1
Could not undo log record (157:203:2), for transaction ID (0:25441), on page (1:6), database 'testebocontrol' (database ID 21). Page information: LSN = (157:194:2), type = 16. Log information: OpCode = 17, context 24.

Connection Broken
<snip>

I have tried doing the restore via E.M. and get similar errors. We backup do a different device each night, and when i tried an earlier backup, that worked fine.
I ran the command

restore verifyonly from ebocontroldbthursday

and it came back saying the backup was fine, as it did for all my backups.

Can anyone shed some light on this error ?

Regards

Jeff

 

[NathanGriffiths]

There seems to be a problem with your transaction log, but I'm not sure what.
This KB link might help you;

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q294902

It recommends installing the latest service pack as a resolution.

HTH

Nathan