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
- 11604 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
Explain iaas, paas and saas?
What is a document index?
What are character string data types in ms sql server?
What happens if an integer is too big for int date type?
Explain the properties of a relational table?
What is single-user mode?
How will you hide an attribute? : sql server analysis services, ssas
What are the restrictions that views have to follow? : SQL Server Architecture
How do you rebuild an identity column?
What is the difference between seek predicate and predicate?
How do I install sql server?
Does hive support indexing?
explain different types of cursors? : Sql server database administration
Is mysql the same as sql server?
What is the difference between ddl and dml?
