emulator Posted June 6, 2009 Report Share Posted June 6, 2009 The instructions for restoring the Master database in SQL Server 2005 are absent from the manual and from the knowledge base. I cannot start SQL server in single user made as suggested in the manual (via the GUI, and NOT via the command line). Any workarounds for this? Quote Link to comment Share on other sites More sharing options...
Mayoff Posted June 8, 2009 Report Share Posted June 8, 2009 This should help: http://kb.dantz.com/article.asp?article=5396&p=2 This is not a Retrospect limitation, it is a SQL requirement for the restore of this database. I believe that the SQL built in backup tools also have the same requirements. Quote Link to comment Share on other sites More sharing options...
emulator Posted October 13, 2009 Author Report Share Posted October 13, 2009 Robin... The article that you pointed to does not apply to SQL Server 2005 (I have no idea about 2008; we are not running it). It took some looking, but here's how to start 2005 in Single User Mode: 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: 3. On the right side of the screen, right-click the item labeled SQL Server (MSSQLSERVER) and select Properties. 4. On the window that appears, click the Advanced tab. 5. Next to Startup Parameters, place a -m; in front of the -dC:\Program Files\...: 6. Click Apply and restart the MSSQL Server Service by clicking Restart on the Log On tab. 7. Restore the Master database as directed in the Retrospect manual. Quote Link to comment Share on other sites More sharing options...
emulator Posted October 13, 2009 Author Report Share Posted October 13, 2009 Robin... The article that you pointed to does not apply to SQL Server 2005 (I have no idea about 2008; we are not running it). It took some looking, but here's how to start 2005 in Single User Mode: 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 (MSSQLSERVER) and select Properties. 4. On the window that appears, click the Advanced tab. 5. Next to Startup Parameters, place a -m; in front of the -dC:\Program Files\...: http://images.morrispress.com/msingle_user.jpg 6. Click Apply and restart the MSSQL Server Service by clicking Restart on the Log On tab. 7. Restore the Master database as directed in the Retrospect manual. Quote Link to comment Share on other sites More sharing options...
emulator Posted October 13, 2009 Author Report Share Posted October 13, 2009 OK...for some reason, my post got posted twice. Sorry about that, folks. 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.