How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
- 3 Answers
- 10088 Views
- HCL, I also Faced
- E-Mail Answers
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
Tell me the phases a transaction has to undergo?
How to find tables without indexes?
What are Row versions of DataRow?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
Does a specific recovery model need to be used for a replicated database? : sql server replication
Why we use the openxml clause?
Why we use trigger in sql server with example?
How to create a view using data from another view?
What is row-level compre?
Why we should not use triggers?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Explain full-text query in sql server?
Explain the cursor lock types?
What are orphan records?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
