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

Is the primary key column of a table an index in ms sql server?

0 Answers  


Explain what is the purpose of sql profiler in sql server?

0 Answers  


How to write character string constants or literals in ms sql server?

0 Answers  


why would you call update statistics? : Sql server database administration

0 Answers  


How many instances per computer are there in sql server 2000?

0 Answers  






How can you find out which stored procedures are recompiling?

0 Answers  


Explain the steps to use transact-sql cursor?

0 Answers  


in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  


What is a coalesce function?

0 Answers  


What is Inner Join?

2 Answers  


Explain Active/Active and Active/Passive cluster configurations

2 Answers  


how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  


Categories