We need to run a SQL server in single user mode at some times like Master database restore, Sysadmin locked out and at some crucial operations.
Open SQL Server Configuration Manager
Select SQL Server Services. After Selecting SQL Services, it will list all the Services available in the machine.
Select Service which you want to run under a single user mode and then Stop services.
Right click on the services. Go to properties. Select StartUp Parameters tab
Then In Specify Parameter Field, add -m and then click add.
Click apply and then Ok.
Start SQL Services & SQL server will come online in single user mode. You can connect using SQLCMD & you can continue with desired operation.
Got questions? Email us at: vembu-support@vembu.com for answers.
Follow our Twitter and Facebook feeds for new releases, updates, insightful posts and more.
