How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?

Answers were Sorted based on User's Feedback



How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mo..

Answer / swapna

Sql Server can be started from command line, using the
Sqlserver.exe. This exe has some very important parameters
with which a Dba should be familiar with.

-m is used for starting Sql Server in single user mode and -
f is used to start the Sql Server in minimal confuguration
mode

Is This Answer Correct ?    10 Yes 6 No

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mo..

Answer / 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

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mo..

Answer / rahul

1) type cmd in rum
2) Stop the Server from configuration manager first and
then In Command Window, Type net start mssqlserver -m for
starting the Service in single user mode.
3) Type net start mssqlserver -f to start the Server in
minimal configration.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to write a query with a left outer join in ms sql server?

0 Answers  


Explain fundamentals of Data ware housing & OLAP?

2 Answers  


What are “unrepeatable reads”?

0 Answers  


How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  


Tell me what is difference between clustered and non clustered index?

0 Answers  






What is a field in a table?

0 Answers  


How to list all stored procedures in the current database using ms sql server?

0 Answers  


What is blocking and how would you troubleshoot it?

3 Answers   HCL,


What are Spatial data types in SQL Server 2008

0 Answers   Infosys,


Can you insert NULL in unique column?

0 Answers   MCN Solutions,


What is set nocount on?

0 Answers  


What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,


Categories