I am runnning SQL7.0 on W2K.
I need to restore a database and its logs. I have restored the database using the NORECOVERY option so the database will accept Transaction Logs.
When I try to restore the logs I get the following error.
Server: Msg 3624, Level 20, State 1, Procedure sp_Reporting_Restore_Log, Line 5
Location: pageref.cpp:3899
Expression: pPage->GetLsn () == lp->GetPrevPageLsn ()
SPID: 12
Process ID: 564
Connection Broken
I have gotten this before and I reran a full backup then did the restore. This time it is not an option.
Thanks in advance
Mat Mathiasen