Interested to Buy Any Domain ? << Click Here >> for more details...
How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
- 3 Answers
- 11365 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
What is default constraint?
Write a query to find 5th highest amount paid from the customer table.
Explain microsoft sql server functions?
Why we use the openxml clause?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What is an identity?
How to check if stored procedure is running in sql server?
What is the difference between NOROW and LOCKROW?
What is the purpose of self join?
what is denormalization? : Sql server database administration
Why we need sql server?
which backup strategy you are following at ur company
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is merge statement?
What is difference between equi join and inner join?
