For more information about how to rebuild the master database, see SQL Server Books Online.Ībove message is very scary and suggest you to do something which you may not want. Restore master from a full backup, repair it, or rebuild it. 10:45:07.94 spid9s Cannot recover the master database. If upgrade script has not run, SQL would shutdown automatically and below would be the message in SQL ERRORLOGs. It has been observed that sometimes, due to system configuration, the script don’t run successfully. This error is normal for sometime till upgrade scripts have completed execution. Only administrator can connect at this time. Reason: Server is in script upgrade mode. 10:45:03.23 Logon Login failed for user ‘NT AUTHORITY\SYSTEM’. This is the time when Login would fail with below error. During the restart, after successful completion, the upgrade scripts are run. During installation of patch the binaries are updated, resource database is replaced. Let’s first understand what happens whenever an upgrade is performed for SQL Server. This is one of the common issue which a DBA might have seen.
0 kommentar(er)
