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 the properties of sub-query in sql server?
Where do we use trace frag?
How to insert stored procedure result into temporary table?
What happens when the SQL Azure database reaches Max Size?
What is difference between after and before?
How do you Implement SSIS Packages in your Project?
What is sql injection and why is it a problem? : sql server security
Explain the purpose of indexes?
In which format does an image save in SQL Server database ?
Explain what is row_number function?
What is use of except clause? How does it differ from not in clause?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Can we write trigger for view?
What are the types of table?
What is snapshot replication?