November 8, 2013 at 4:45 pm
I have a script that runs to restore prod db to a test server.
It first set the destination db to single use mode, then restore. The job runs successfully, restore is good too, but I just see in the SQL server log files there are some info messages like below:
The database 'MyDB' is marked RESTORING and is in a state that does not allow recovery to be run.
Then later message said CHECKDB for database 'Mydb' finished without errors.
What does the underlined message mean?
Thanks
November 9, 2013 at 2:03 am
That the database is in a restoring state (it's in the middle of a restore) and hence SQL can't run recovery on it at this point in time.
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 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply