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
List the different types of collation sensitivities in sql server?
What happens if null values are involved in string operations?
Explain what are the authentication modes in sql server?
How to bind a view to the schema of the underlying tables?
What is an sql server agent?
What are entities and relationships?
Explain stored procedure?
How to create a view on an existing table in ms sql server?
How to search for a string in all stored procedure in sql server?
What is 2nf normalization form?
Why should one not prefix user stored procedures with ‘sp_’?
How to write a query with a full outer join in ms sql server?
How to send email from database?
What is data source view or dsv? : sql server analysis services, ssas
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?