How to start SQLServer in single user mode?
In some bad situations like whenever your master databse or other system databases got damaged you might need to start the SQL Server in single user mode in order to recover/restore.
Starting SQL Server in single-user mode enables any member of the computer's local Administrators group to connect to the instance of SQL Server as a member of the sysadmin fixed server role
How will I do that?
- Click on Start button à Run
- Type services.msc and then enter (this opens service applet)
- Goto the SQLService and double click on it and stop it.
- Type “-m” in Startup Parameters box
- Now start the service
Connect to the sql server through SSMS and restore/recover Master database or any system database, after recovering don’t forget to remove “-m” from Startup Parameter.
No comments:
Post a Comment