Start SQL Server in different modes?

Published on by LakshmiSaahul,Dhana Royal

Start SQL Server in different modes?

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: ALTER DATABASE test_db SET EMERGENCY

Advertising
To be informed of the latest articles, subscribe:
Comment on this post