How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
Answer Posted / rahul
1) type cmd in rum
2) Stop the Server from configuration manager first and
then In Command Window, Type net start mssqlserver -m for
starting the Service in single user mode.
3) Type net start mssqlserver -f to start the Server in
minimal configration.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between primary keys and foreign keys?
To which devices can a backup be created and where should these devices be located? : sql server management studio
In which tcp/ip port does sql server run? Can it be changed?
what are the different types of replication you can set up in sql server? : Sql server database administration
How many types of built in functions are there in sql server 2012?
what is raid and what are different types of raid configurations? : Sql server database administration
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What options are available to audit login activity? : sql server security
Explain different types of locks in sql server.
How to select all columns of all rows from a table with a select statement in ms sql server?
What is truncate table?
What sql server means?
What is an expression in ms sql server?
What is a unique key constraint?
Explain various On-Delete options in a DB table. Which is the default option?