Post reply

SQL 2005 Restores Stuck in (Restoring...) Mode

  • November 12, 2007 at 9:07 am

    #184199

    I'm doing test restores and my SQL 2005 restores keep getting stuck in (Restoring...) mode. I'm doing a simple test from one SQL 2005 server to another using a basic database (actually any database).

    The wierd thing is that SQL says the restore "Completed Successfully" and yet I see the (Restoring...) message. Here's the error I get when I attempt to open the restored DB, "Database 'test2' cannot be opened. It is in the middle of a restore. (Microsoft SQL Server, Error: 927)".

  • November 12, 2007 at 10:26 am

    #750322

    Please state what steps and options you are selecting in the restore steps. Specifics help in diagnosing issues :):)

  • November 12, 2007 at 10:55 am

    #750324

    When you restored did you leave in a NORECOVEY or STANBY state?

    Try: Restore database DBName with Recovery

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • November 12, 2007 at 4:10 pm

    #750408

    Thanks to all who replied. It turns out this is a normal state when using NO RECOVERY and setting up for Mirroring. Once the mirrored db is created, then the status changes to (Mirror, Synchronized/Restoring). Thanks.

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

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