How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
Answer Posted / swapna
Sql Server can be started from command line, using the
Sqlserver.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 ? | 10 Yes | 6 No |
Post New Answer View All Answers
What is ssrs?
Why we need sql server?
What is snapshot parameter in ssrs?
What is full outer join in sql server joins?
What is RAID? What are the different types of RAID configurations?
Can sql servers link to other servers?
Does partitioning help performance?
Is sql server 2016 free?
Why would you use sql agent?
How can you start sql server in different modes?
How global temporary tables are represented and its scope?
What is the difference between the application object and session object?
Explain the creation and execution of a user-defined function in the sql server?
What is sql server profiler?
What is an entity-relationship diagram (erd)?