Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master DB restore, Sysadmin locked out etc. Steps to start SQL Server in Single User Mode :- 1) Stop SQL Server Services 2) Add [-m] startup parameter in SQL Services from configuration manager Parameter [-m] Starts … Continue reading
How to Start SQL Server in Single User Mode ?
Original post (opens in new tab)
View comments in original post (opens in new tab)