January 2, 2009 at 11:02 am
A database is in "It is in the middle of a restore" state. How do I release that state for that database? Thanks.
January 2, 2009 at 11:23 am
Nothing can be done, you have to wait till entire database or log restoration is completed.
January 2, 2009 at 1:16 pm
That depends. If it is really in the middle of restore operation, then you will just have to wait until the restore operation is over. If on the other hand you restored the database with norecovery option and the restore was done, then you can just issue restore database DBName with recovery (instead of DBName you have to write the database’s name).
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 3, 2009 at 7:37 am
thuybui (1/2/2009)
A database is in "It is in the middle of a restore" state. How do I release that state for that database? Thanks.
What did you do to get it into that state in the first place?
Any errors in the error log?
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