August 26, 2015 at 3:43 pm
Hello,
Our Windows team was applying patches to servers at work and during the patch update our users started to complain that they could not access some applications that are on a specific server.
When I logged on to the server and tried to launch the SSMS, I got a connection failure message.
I went to the Event Viewer and read that the read is related to the 'master' database having failed. Below is the full error message:
---
Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 2714, state 6, severity 25. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. 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.
---
How do I restore the 'master' database while not having access to the SQL server?
Thank you very for your help!
August 27, 2015 at 3:22 am
August 27, 2015 at 8:27 am
Hi!
Thank you for the information. We were able to resolve the issue by following the direction set in this article:
https://msdn.microsoft.com/en-us/library/dd207003(v=sql.105).aspx
Thanks a lot!
August 28, 2015 at 3:17 am
Good deal! Thanks for the feedback. Others may one day have the same issue as you and it helps to get everything documented.
Joie Andrew
"Since 1982"
September 2, 2015 at 6:47 am
Have you tried uninstalling the offending patch first from add\remove programs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply