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 it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  


Difference between report and query parameter.

0 Answers  


What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

0 Answers  


can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  


What is key attribute?

0 Answers  






What are the differences between substr and charindex in sql server.

0 Answers  


write the query for taking database restore in sql?

2 Answers  


What are the steps you should follow to start sql server in single-user mode?

0 Answers  


How to loop through result set objects using odbc_fetch_row()?

0 Answers  


What are the differences between user defined functions and stored procedures?

0 Answers  


how many instance use in sql server 2005

4 Answers   EFI, HCL,


What happens if ntwdblib.dll is missing on your machine?

0 Answers  


Categories