Hi,
I'm getting error:
An error occurred while processing the log for database ' '
when trying to restore first transaction log backup after successful restore of full backup on SQL 2000. Note that database name is blank.
What's the cause and the solution Please help.
Log restore failure
Shay777
Hi Rob,
I'm getting the same error (no additional error information) when running a restore procedure executed by our program. I can't run it in query tool now because production moved on and I can not replicate the problem again. Note, that it was happening at first tran. log restore and the database name was blank. It could be something to do with information written at full backup about next tran. log back up.
With thanks,
Kris
Ferdynand
Hi Kris,
I'd recommend you not use EM to perform the restore, but rather issue a restore command from Query Analyser. At times, EM can hide or otherwise suppress error/warning details from you. Once you've restored the database with NORECOVERY, then you can start applying the transaction logs (in the correct order). If you receieve an error at this point, can you post the full error message
Cheers
Rob
rewan
So you are restoring sql2000 backups on sql2005
This is supported, but you can't restore WITH STANDBY when the backup is "downlevel". I suspect that if you don't try the "readonly" option in the GUI, then it will work.
To help further, I'd need the actual errorcode that you are receiving from the engine.
jalegom
Hello,
Can you provide some more details How are you attempting to restore the log How have you restored the database Did you restore the DB with the NORECOVERY clause
Cheers
Rob
Chandu Narina
Hi,
I've restored full backup using Enterprise Manager to read-only mode, then tried to do the same with the transaction log.
Thanks,
Kris