Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013
    Posts
    1

    Red face Unanswered: 'sqlagent100_msdb_upgrade.sql' encountered error 200, state 7, severity 25.

    Hello,

    I'm getting the following error after applying the service pack 2 on SQL server 2008 R2. Instance in not coming up.

    Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 200, state 7, 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.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    When you start SQL Server, does anything show in the errorlog? If not, start the instance from the command line, and see what response you get.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •