How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
Answer Posted / ganeshsamurti
• Open "Control Panel->Administrative Tools->Services"
• Mouse right click on specified SQL Server instance service
and select "Properties" menu to bring up following
configuration window:
• Specify start parameters as following:
-s{ Instance name } -m
If instance is default instance (no instance name) ,then
just enter
-s -m
• Restart the SQL Server instance service
SQL Server can be started from command line, using the
SQLSERVR.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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain cdc and sql injection?
What is a raid and what are different types of raid configurations?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Is foreign key a primary key?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
How sql server executes a statement with nested subqueries?
How to remove duplicate rows from table except one?
What is sparse columns of sql server 2008?
What is the purpose of optimization?
How to convert binary strings into integers in ms sql server?
Explain hostprotectionattribute in sql server 2005?
Difference between report and query parameter.
What are the aggregate and scalar functions?
Describe different Processing Modes offered by SSRS?
What is ms sql server triggers?