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

Protect Your Data with BDRSuite

Cost-Effective Backup Solution for VMs, Servers, Endpoints, Cloud VMs & SaaS applications. Supports On-Premise, Remote, Hybrid and Cloud Backup, including Disaster Recovery, Ransomware Defense & more!

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.

step1

Download Banner

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.

step2

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.

Rate this post