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
- 11634 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 what are the different index configurations a table can have?
What is database dimension? : sql server analysis services, ssas
Can you explain different types of joins?
What are sql dirty pages?
Define clusters?
Explain what is the main purpose of having conversation group?
How data can be copied from one table to another table?
What are two difference between sql azure and azure tables?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What are Spatial data types in SQL Server 2008
Mention the 3 ways to get a count of the number of records in a table.
How to change the system date and time from SQL Plus Terminal ?
How to create a simple user defined function in ms sql server?
What is role playing dimension with two examples? : sql server analysis services, ssas
What do you mean by the term 'normalization'?
