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


Please Help Members By Posting Answers For Below Questions

List the different types of collation sensitivities in sql server?

698


What happens if null values are involved in string operations?

690


Explain what are the authentication modes in sql server?

653


How to bind a view to the schema of the underlying tables?

725


What is an sql server agent?

695






What are entities and relationships?

718


Explain stored procedure?

745


How to create a view on an existing table in ms sql server?

765


How to search for a string in all stored procedure in sql server?

698


What is 2nf normalization form?

749


Why should one not prefix user stored procedures with ‘sp_’?

764


How to write a query with a full outer join in ms sql server?

698


How to send email from database?

733


What is data source view or dsv? : sql server analysis services, ssas

725


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

728