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

What is use of except clause? How it differs from not in clause?

0 Answers  


Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  


How to modify the underlying query of an existing view?

0 Answers  


How do you debug a procedure in sql server?

0 Answers  


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  






Does a specific recovery model need to be used for a replicated database? : sql server replication

0 Answers  


Can you get second highest salary from the table?

0 Answers   QuestPond,


What is tcl in sql server?

0 Answers  


What is exporting utility?

0 Answers  


What is transactional replication?

0 Answers  


How the data stores in a page?

1 Answers  


What do you understand by a view?

0 Answers  


Categories