SQL 2012 SP to upgrade

• salamlemon

  SSC-Addicted

  Points: 489

  More actions

  July 2, 2015 at 7:12 pm

  #398688

  Hi Guys,

  This morning I ran SQL 2012 SP2 upgrade in windows 2012 environment. I mistakenly didn't run the exe as administrator, however my windows login is added to local administrator group.

  Now, after the installation finished, I couldn't start SQL Server Service. In the error log found this error message:

  "Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 598, state 1, 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 Error log entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion."

  Any idea why this could happen?

  Thanks

• JManuelN

  SSCommitted

  Points: 1708

  More actions

  July 3, 2015 at 3:28 am

  #1810151

  Hi,

  Please check this KB if this case suits to your current issue even if it is a SQL Server 2008R2

  https://support.microsoft.com/en-us/kb/2163980

  Other troubleshoot option would be these ones

  http://blogs.msdn.com/b/karthick_pk/archive/2010/11/18/sqlserver2008-script-level-upgrade-for-database-master-failed-because-upgrade-step-sqlagent100-msdb-upgrade-sql-encountered-error-574-state-0-severity-16.aspx

  https://arshpreet9.wordpress.com/2013/02/12/error-on-2008-and-2012-script-level-upgrade-for-database-master-failed-because-upgrade-step-msdb110_upgrade-sql/