SQL Administrator Question:
Download Job Interview Questions and Answers PDF
How to start SQL Server in different modes?
Answer:
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
DAC (-A): sqlcmd –A –d master –S PAXT3DEVSQL11 –c –U sa –P *******
Emergency: ALTER DATABASE test_db SET EMERGENCY
Download SQL Administrator Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Please explain why would you call Update Statistics? | Tell me what is SQL Server VSS Writer? |