emulator Posted October 14, 2009 Report Share Posted October 14, 2009 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.