Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’

Resolution:

  1. Run regedit.exe
  2. Navigate to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Setup
  3. Note down the path of SQLDataRoot, example: C:\Program Files\Microsoft SQL Server\MSSQL10_50.<SQLInstanceName>\MSSQL
  4. Navigate to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.<SQLInstanceName>\MSSQLServer
  5. Verify if the path in DefaultData/DefaultLog looks similar to the path in SQLDataRoot
  6. DefaultData path should be similar as: C:\Program Files\Microsoft SQL Server\MSSQL10_50.<SQLInstanceName>\MSSQL\DATA
  7. DefaultLog path should be similar as: C:\Program Files\Microsoft SQL Server\MSSQL10_50.<SQLInstanceName>\MSSQL\Log
  8. Update these path if it’s invalid
  9. Restart the SQL Server Agent if necessary
  10. Problem solve

*Replace <SQLInstanceName> with your database instance name

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s