This particular problem in the master database, but I have also seen it in SSISDB and MSDB as well. In my experience, this typically means that an error occurred in one of the scripts the patching process was trying to run.
Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion. If the error happened during upgrade of the ‘master’ database, it will prevent the entire SQL Server instance from starting. This is a serious error condition which might interfere with regular operation and the database will be taken offline. You will typically find something along these lines: Script level upgrade for database ‘master’ failed because upgrade step ‘ISServer_upgrade.sql’ encountered error 15559, state 1, severity 16. Now that you have SQL Server up and running (hopefully) look through the error log until you find the dreaded “Cannot Recover Master Database” error and continue to look through the log at the errors preceding that error. (Sometimes specifying the -m parameter to start in single user mode works too) If this works and SQL Server comes online, congratulations, your master database is just fine and you are just a few steps away from getting this problem fixed! You need to try starting your SQL Service specifying Trace Flag 902 at startup. Or, you can try to bring SQL Server online and view the log in SSMS like you normally would. One way to do this is browse directly to the folder containing the SQL error logs and try to open the error log in notepad to get more detail on why the SQL instance will not start. In order to find out what’s really going on, you need to look at the SQL Server error log. I wish Microsoft would change this to something a little less terrifying, like “An error occurred during the patching process, see log for details.” But, they didn’t ask me… Next, Figure Out What Really Happened
First, Don’t Panic!Īs I said, this error can be misleading. The good news is, most likely this is a false error and the master database is perfectly fine. Actually, this seems to be the default error that Microsoft throws any time there is a problem with the patching process. This is not the first time I have seen this error. Restore master from a full backup, repair it, or rebuild it. It was throwing the following heart attack inducing error: Cannot recover the master database. Recently, during patching for a 2019 SQL Server, the SQL services refused to start after the patching.
0 kommentar(er)
