after installing SP2 instance starts and stops with error:
Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 5831, state 1, severity 16. 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.
Already tried without success:
- enabled SA account (was disabled)
- uninstalled SP2 -> other error, but same problems with running the script
View Complete Post