Interested to Buy Any Domain ? << Click Here >> for more details...
How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
- 3 Answers
- 11767 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 is inner join? Explain with an example?
What is the difference between Clustered and Non-Clustered Index?
What is the purpose of forms?
What is 2nf normalization?
What stored by the model?
what is denormalization and when would you go for it? : Sql server database administration
Explain concepts of analysis services?
what are the critical issues you have resloved in your company
What are the different types of replication you can set up in sql server?
Explain the cursor lock types?
What is service broker?
Tell me what is the stuff and how does it differ from the replace function?
What are .mdf files?
What are the different sql server versions?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
