How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
- 3 Answers
- 10681 Views
- I also Faced
- E-Mail Answers
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
Other than truncate statement, which other command can by-pass the trigger on the tables?
What do you mean by subquery?
how can you check the level of fragmentation on a table? : Sql server administration
Write an SQL query to obtain the 2nd highest salary.
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What is shrink log file?
Explain the working of sql privileges?
How will you hide an attribute? : sql server analysis services, ssas
What is measure group, measure? : sql server analysis services, ssas
Explain how many normalization forms?
How to get all stored procedures in sql server?
How do we know if any query is retrieving a large amount of data or very little data?
Explain the database you used in your final year project?
What is nolock hint in sql server 2008
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
