Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-03 : 09:17:28
|
| Matt writes "SQL server 7.0 spk 2, 2 * processor box, windows 2000 serverThis call is not causing any other problem other than catching my curiousity.Situation - We have production database backed up everynight into a dump directory. Everynight after the backup is complete we restore the backup into an accepatnace testing environment using a scheduled job with the following code - RESTORE DATABASE [prodaccHealthware] FROM DISK = N'F:\Dumps\prodHealthwareBackup.BAK' WITH FILE = 1, NOUNLOAD , STATS = 10, RECOVERY , REPLACE,MOVE N'testMaternity_Log' TO N'D:\Logs\prodaccHealthware_log.ldf', MOVE N'testMaternity_Data' TO N'G:\Groups\SQLDBS\prodaccHealthware.mdf'Problem - At the same time that the restore is happening we get an error log entry -Bypassing recovery for database 'prodaccHealthware' because it is marked IN LOAD.This is usaully preceeded by -Starting up database 'prodaccHealthware'.Opening file D:\Logs\prodaccHealthware_log.ldf. I can understand that the database is being loaded but what does "bypassing recovery" actually mean?. From the "Restore" statement above the "recovery" option is chosen so there should be no bypassing.Thanks for your help" |
|
|
|
|
|
Transaction log mystery