December 18, 2012 at 12:38 pm
SQL Server 2005
I ran Restore with recovery and now getting
Msg 927, Level 14, State 2, Line 1
Database 'XXXX' cannot be opened. It is in the middle of a restore.
December 18, 2012 at 1:18 pm
Did the restore finish without error?
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
December 18, 2012 at 3:35 pm
No the restore never finished. It like it was just hung. There is no job running for it. I end up dropping and attempt to restore again since this is restoring one database to another. Just wanted to know for future--what can I do if anything but drop the database.
Thks in advance...
December 18, 2012 at 3:54 pm
If the restore never finished, drop the DB and restore again.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply