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
What is a with(nolock)?
How do you create a clustered index?
what's the information that can be stored inside a bit column? : Sql server database administration
How to use go command in "sqlcmd"?
wat wil hapn if we give the both read and deny read permission to user?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How do I open a .db file?
Who developed sql server?
How to return the top 5 rows from a select query in ms sql server?
What are the types of sql server?
Define self join?
Does any body please help me what question's have asked for SSRS in the interview?
How to list all stored procedures in the current database using ms sql server?
Do you know concepts and capabilities of sql server?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas