Bypassing recovery..marked IN LOAD

• AVB

  SSChampion

  Points: 11418

  More actions

  May 22, 2006 at 7:57 am

  #112407

  I restored my db backup. It terminates abnormally with the this error in the logs:

  Bypassing recovery for database '5_22_06' because it is marked IN LOAD.

  I have specified With Recovery. There is only one file in the Backup. Could this be caused by a corrupt backup?  Is there any way to load the database after this backup has run even though it has terminated abnormally?

   

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  May 22, 2006 at 8:19 am

  #639277

  Are you sure the database finished loading? How long did it take to make the backup and how long has the restore gone on?

  You might try running just:

  RESTORE DATABASE dbname

  WITH RECOVERY

  (Change dbname to your real database name).

  You might also try posting your RESTORE command so we can see if there was anything wrong with it (syntax errors).

  -SQLBill