Jump to content
Sign in to follow this  
emulator

Restoring MSDB database on SQL Server 2005

Recommended Posts

Hi all...

 

There is a missing step in restoring databases in the Retrospect manual for SQL Server 2005. Specifically, the restore of the MSDB database may fail if the SQL Server Agent (MSSQLSERVER) service is running. To shut this service down:

 

1. Launch SQL Server Configuration Manager located at Start/All Programs/Microsoft SQL Server 2005/Configuration Tools.

 

2. On the left side of the screen, expand the item labeled SQL Server Configuration Manager (Local) and select SQL Server 2005 Services:

 

http://images.morrispress.com/services.png

 

3. On the right side of the screen, right-click the item labeled SQL Server Agent (MSSQLSERVER) and select Stop.

 

You should now be able to restore the MSDB database.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×