How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
Answer Posted / m.sivakumar
The SQLSERVR.EXE is located in binn directory of Sql server.
-m is used for starting SQL Server in single user mode.
-f is used to start the SQL Server in minimal configuration
mode.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How do users use Report Builder with SQL Server data sources?
How to create an multi-statement table-valued function?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What do you understand by physical_only option in dbcc checkdb?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is an execution plan? When would you use it?
What xml support does the sql server extend?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Can you pass expressions to stored procedure parameters?
How to connect Azure federated root database and apply federation in entity framework?
How we create SQL Server 2005 Reporting Services ? Give me Sample
Is it important for a database administrator to understand the operating system and file access?
Data table as parameter in sql server?
What is database architecture? : SQL Server Architecture