We can start SQL Server in different modes which are follows:-
- Single User Mode (-m)
- DAC (-A)
- Emergency Mode
- Single User Mode (-m): sqlcmd –m –d master –S PAXT3DEVSQL11 –c –U sa –P
- DAC (-A): sqlcmd –A –d master –S PAXT3DEVSQL11 –c –U sa –P
- Emergency Mode : ALTER DATABASE test_db SET EMERGENCY