Post reply

Stuck in restore

  • November 13, 2009 at 9:27 am

    #212288

    My db is stuck in restoring for hours...

    I've stopped and restarted the service, no luck

    I do a sp_who2, nothing blocked killed all the spids I could, no luck...

    Next step?

  • November 13, 2009 at 9:51 am

    #1079057

    I am making the assumption that you were restoring the database from a backup?

    Try this:

    restore database [YourDatabaseName] with recovery;

  • November 13, 2009 at 9:59 am

    #1079065

    Tried that already...

    Msg 4333, Level 16, State 1, Line 2

    The database cannot be recovered because the log was not restored.

    Msg 3013, Level 16, State 1, Line 2

    RESTORE DATABASE is terminating abnormally.

  • November 13, 2009 at 10:08 am

    #1079075

    How did you restore? Please post the exact script that you used. Check the SQL error log. Post all errors relating to that DB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 13, 2009 at 11:35 am

    #1079155

    Got it, had to drop the MDF/LDF....and reatore..nothing else worked thanks

  • November 13, 2009 at 11:45 am

    #1079163

    It sounds like you were trying to restore over an existing database, next time give the WITH REPLACE option a try.

    restore database test from disk = 'c:\test.bak' WITH REPLACE

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

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