SQL Administrator Question:
Download Job Interview Questions and Answers PDF
Tell me what action plan is prefered if SQL Server is not responding?
Answer:
Connect 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
☛ 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
Download SQL Administrator Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell us what are the different SQL Server Versions you have worked on? | Tell us what is SQL Server Integration service and its importance? |