June 12, 2002 at 7:29 am
Hi All,
I restored a SQL Server 2K database successfully with a full db backup. But when checking SQL Server logs, I saw message "bypassing recovery because Database is marked IN LOAD". The message for the log seems to be conflict with that from the restore process. Was the db really restored successfully? Could someone advise me on this?
The db property was set Bulk-logged and can be retored sucessfully; if I changed it to Full, I could also restore it succeffuly, but this property automatically changed back to Bulk-logged. Why is this property changed silently during the restore process?
Thank you in advance for your help!
Yichang
June 12, 2002 at 7:50 am
Hi
hmm.. this is a strange one. From all the restores ive done over the years (v7/ss2k) the recovery model is restored "as is" based on the properties setting at the time of the full backup. Are you restoring a full only with no other differentials or logs?, only thing that I can think of as rough guess.
For the IN LOAD status, can you access the DB via query analyser or EM without any obbviuous issues to subsequent errors in the sqlserver log?
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
June 12, 2002 at 8:41 am
Have you tried RESTORE DATABASE MyNwind WITH RECOVERY?
Andy
June 12, 2002 at 8:45 am
Hi,
The db was restored successfully with or without transaction logs. I was able to select after restore.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply