Tell me what action plan is prefered if SQL Server is not responding?
Submitted by: MuhammadConnect using DAC via CMD or SSMS
☛ Connect via CMD
☛ SQLCMD -A –U myadminlogin –P mypassword -SMyServer –dmaster
☛ Once you connect to the master database run the diagnostic quires to find the problem
☛ Correct the issue and restart the server
Submitted by: Muhammad
☛ Connect via CMD
☛ SQLCMD -A –U myadminlogin –P mypassword -SMyServer –dmaster
☛ Once you connect to the master database run the diagnostic quires to find the problem
☛ Correct the issue and restart the server
Submitted by: Muhammad
Read Online SQL Administrator Job Interview Questions And Answers
Top SQL Administrator Questions
| ☺ | Tell me why would you use SQL Agent? |
| ☺ | Please explain why would you call Update Statistics? |
| ☺ | How to start SQL Server in different modes? |
| ☺ | Tell me what is SQL Server VSS Writer? |
| ☺ | Do you know what is SQL Server service and its importance? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
