Database 'mssqlsystemresource' is being recovered. Waiting for SQL Server to start
I'm using the SQL Server Express 2012 SP1 service. Which is working well. However I've had to add some extra logic to my 'before build' script because the database isn't quite ready to use when it's started.
The error I sometimes get is:
Error: Exception calling "ExecuteNonQuery" with "0" argument(s): "Database 'mssqlsystemresource' is being recovered. Waiting until recovery is finished."
I've got round this by having some wait/retry logic in a PowerShell script, but would be great if the before build script wasn't fired until after this recovery is complete.
In the meantime the script I'm using is: https://gist.github.com/jonathanhickford/1cb0d6665adab8b9c664
Comments are currently closed for this discussion. You can start a new one.
|?||Show this help|
|ESC||Blurs the current field|
|r||Focus the comment reply box|
|^ + ↩||Submit the comment|
You can use
Command ⌘ instead of
Control ^ on Mac
Support Staff 1 Posted by Feodor Fitsner on 23 Jun, 2014 05:34 PM
Well, I see no issues in your script, theoretically, it should be fine. I think that error is related to SQL Server engine itself. Try adding some delay before running the script to let SQL engine to "warm up".
Ilya Finkelshteyn closed this discussion on 25 Aug, 2018 01:45 AM.