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
- 11452 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 are the differences between ms sql server & oracle?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What protocol does sql server use?
What triggers long term care?
What is 1nf 2nf and 3nf?
How to delete multiple rows with one delete statement in ms sql server?
What is Sqlpaging in SqlServer 2005 ?
Can you explain what are various ways to enhance the ssrs report?
How to provide values to stored procedure parameters in ms sql server?
What is update locks?
List the types of recovery model available in sql server?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Explain the various types of concurrency problem?
Why truncate is ddl?
What are the differences between having and where clause.
