How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
- 3 Answers
- 10682 Views
- I also Faced
- E-Mail Answers
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
what protocol both networks use? : Sql server database administration
What is the sql server agent?
How to verify a login name with sqlcmd tool?
Do you know what is difference between index seek vs. Index scan?
How to insert data with null values?
What is blocking and how would you troubleshoot it? : sql server database administration
Can we create clustered index on composite key?
What is raiseerror? What is raiseerror?
How can we improve performance by using SQL Server profiler?
You want to use a perspective in an mdx query. How do you select the perspective?
What is the security principal at the database level that represents your session?
What do you mean by a Composite primary key?
Which command is used for user defined error messages?
We need to perform what steps in the following order to work with a cursor?
How to convert numeric expression data types by assignment operations?
