Jump to content
Sign in to follow this  
emulator

Starting SQL Server 2005 in single server mode

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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:

 

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\...:

 

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.

Share this post


Link to post
Share on other sites

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.

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  

×