5/9/2023 0 Comments Master db in sql server![]() ![]() 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. Script level upgrade for database ‘master’ failed because upgrade step ‘msdb110_upgrade.sql’ encountered error 5846, state 1, severity 16. I have to restore or rebuild the master database due to this service pack failure? Well guess what, I don’t have a master database backup and I don’t really want to rebuild the master database. For this example it is called SQLServer_ERRORLOG_T10.17.57 It is not that detailed so based on the time-stamp highlighted above I go looking at a detailed one. The first one I usually go to is the summary file: Now is the time to start working through the error logs. This is where you will have all the information you need for troubleshooting. ![]() If you navigate to the following directory location: C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\ ![]() I wanted to move from SQL Server 2014 SP1 to SP2, as you can see I had a clear issue. Initially I wasn’t going to capture the screen shots during this recovery because my focus was to fix the issue but I thought I would just in case others experience the same thing. I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade, if not you might want to reconsider.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |