November 12, 2007 at 9:07 am
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
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
November 12, 2007 at 4:10 pm
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