How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
Answer Posted / sqlserverbuddy
1. STOP the SQL Server Service(Management Studio or Service)
2. Step into Root directory of the SQL server Instance
(Default or Named Instance)
3. Enter as given below for Default Instance
sqlservr -m
4. Enter as given below for Named Instance (MyServer)
sqlservr -m -s MyServer
5. Don't close the DOS screen which processing internal
activities.
6. Open the SQL Server management studio and Proceed
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
how you can get the list of largest tables in a database? : Sql server administration
List out what other servers you can use with ssrs?
How to find the list of fixed hard drive and free space on server?
What do you mean by SQL injection attack?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
How to enter comments in transact-sql statements?
List out the difference between union and union all in sql server?
Explain the Ways to improve the performance of a sql azure database?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
How do I uninstall sql server 2014?
What is oltp (online transaction processing)?
What are four major operators that can be used to combine conditions on a where clause?
how to define testing of network layers? : Sql server database administration
Explain the relational database management system (rdbms)?
What is provisioning, billing and metering, and connection routing concepts in the service layer?