How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
Answer Posted / 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 |
Post New Answer View All Answers
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What are the tools available in market as an alternative to sql server reporting services?
How to encrypt Strored Procedure in SQL SERVER?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What is a partition key?
How to add the custom code in Report?
How can we improve performance by using SQL Server profiler?
Do you know concepts and capabilities of sql server?
How to delete duplicate rows?
What is primary key, unique key, and foreign key?
What is openxml in sql server?
What are statistics?
What is subquery explain with example?
Do you know what are acid properties of transaction?
A trigger can reference objects outside the current database? State true or false.