1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / m.sivakumar

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 / m.sivakumar

The SQLSERVR.EXE is located in binn directory of Sql server.

-m is used for starting SQL Server in single user mode.
-f is used to start the SQL Server in minimal configuration
mode.

Is This Answer Correct ?    7 Yes 1 No

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

Answer / hanumathkumar

-m is used for starting SQL Server in single user mode.
-f is used to start the SQL Server in minimal configuration
mode.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is the difference between clustered and a non-clustered index?

0 Answers   NA,

What is set nocount on and what is set nocount off?

0 Answers  

What is WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,

Can group functions be used in the order by clause in ms sql server?

0 Answers  

What is the difference between row_number and dense_rank?

0 Answers  




What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

What are transactions in sql?

0 Answers  

What is a covered index?

0 Answers  

last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

Please differentiate between a local and a global temporary table?

0 Answers  

Explain syntax for viewing trigger?

0 Answers  

What is DAC? what is the use of it?

1 Answers   Wipro,

For more SQL Server Interview Questions Click Here
Categories