How to start Microsoft SQL in Single User mode


I have used this option when I have needed to migrate a SQL server to different hardware and need to restore the MASTER database.

  • Open a command prompt
  • Type net stop mssqlserver
  • Use the cd command to locate your SQL installation ie) mssql\sqldata\binn
  • Type sqlservr –m

The server opens in single user mode. When you have finished with the single user mode stop and start the mssqlserver service to start the instance of SQL in normal mode.

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