How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
- 3 Answers
- 10360 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
How does clustered and non clustered index work?
What do you know about system database? : SQL Server Architecture
What is the sql server agent?
How to list all columns in a table using odbc_columns()?
What are the requirements on sql server network connections?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is sql or structured query language?
Explain following error properties?
what's the difference between a primary key and a unique key? : Sql server database administration
Which trace flags are enabled in sql server?
Why functions are used in sql server?
What is the difference between Stored Procedures and triggers?
Explain time data type in sal server 2008?
What are a scheduled jobs?
what are triggers? : Sql server database administration
