Post reply

restored db in loading mode

  • March 6, 2007 at 12:18 pm

    #62637

    I restored a 2 GB backup (simple mode) db. the backup was taken from sql to a file: .bak. The restore completed but the db says loading in Enterprise Manager. I see the follwing entry in sql logs:

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

    Its been over 2 hrs the db is "LOADING" mode. Not sure if this is OK, any suggestions.

    This is SQLSERVER 2000 on windows 2003.

    thanks,

     

  • March 6, 2007 at 2:31 pm

    #693419

    Did you try to run

    RESTORE DATABASE dbName WITH RECOVERY?

  • March 7, 2007 at 5:10 am

    #693519

    If its still running now then you have a problem. Try and use query analyser to run your T-sql RESTORE command. That way you can get feedback that the query is still executing.

  • March 7, 2007 at 10:37 am

    #693616

    I re-restored the db and it came up right away.

  • March 7, 2007 at 4:26 pm

    #693692

    You 'probably' used WITH NORECOVERY when you did the first restore. That will leave the database in LOADING mode as it is waiting additional restores.

    -SQLBill

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply