Windows patches applied to a physical 2003 server running SQL 2008 Enterprise at around 7.00am
We used VMware Protect Essentials to deploy the patch using the shutdown SQL an IIS service options.
Patch 'SQLServer2008-KB2716433-x86.exe' was insatlled and SQL Server shutdown and we are in a left in a position where we cannot restart any of the services
Windows Event Log displayed error: 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 the 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.
The above sql patch changed our version of SQL Server 2008 From ‘1033 196609 4311’ to ‘1033 196609 4371’
We tried to start up sql server in single user mode from command prompt using the /f or /m options but were unable to restore the master database to a backup from yesterday. It errored. We got an error saying the master db needed restoring (I think that was misleading, as it works with /t902) but when we tried to, following the KB articles to restore the Master db, we got a new error saying the versions where different.
We were unable to get the sql server started so we uninstalled the update SQL Patch from windows add/remove hoping it would solve the issue once we rebooted but this did not work.
Finally we decided to use the /T902 trace flag on startup for all our sql services (we ran this from the command line and did not update the start up parameters through the SQL Server Configuration Manager – unable to get this to work).
Current version of SQL: Microsoft SQL Server 2008 (SP2) - 10.0.4311.0 (Intel X86) May 11 2011 14:52:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)
We are now up and running by manually starting the SQL services using the command 'net start <service> /T902', but if we remove the /T902 flag we are back to the script level upgrade error message and unable to restart sql server services.