How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
Answers were Sorted based on User's Feedback
Answer / swapna
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. Check
out SQL Server books online for more parameters and their
explanations.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / abc
sqlserver.exe is located in the binn dir of sql server ie
program files\m sql server\mssql\binn and we can get help
related to it on dos prompt
to start server at single user mode or admin role we have
to specify -m ahead of the command
Is This Answer Correct ? | 0 Yes | 1 No |
What are indexers?
what is a stored procedure and trigger?
What part does database design plays a role in performance of an sql server-based application?
What is the Difference Between Primary and Foreign Key?
0 Answers Accenture, Deloitte, JPMorgan Chase, Maveric,
What is Pointer ?
3 Answers Cap Gemini, CarrizalSoft Technologies,
How to drop an existing user defined function in ms sql server?
Explain system rowset functions?
what is sql injection in sql server?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Questions regarding Raiseerror?
How to provide column names in insert statements in ms sql server?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?