vinodh247 (1/5/2011)
Hi all,Below are the q's I faced in the interview I've attended yesterday...if anybody knows all the best answer pls contribute.
1) Log shipping/Replication/Mirroring/Clustering-uses-steps to implement it
2) What will you do if sql server is slow
3) What will you do if tempdb, transaction log file is full
4) How to take tail backup if db is corrupted-steps
5) Can we change the default port/if yes what is the use of doing it?
6) Where will you check the error apart from activity monitor in ssms? what will you do if the error log file is missing?
7) How do you check disk space/ How do you resolve if you have any issues?
8) How do you check/solve blocking issues
9) What are the frequent database issues you face in your present job & how you troublshoot it?
10)What is the sev3/sev4 issue you have faced till now?
Part of being a DBA is being able to research and find the answers for such questions on your own. And, I have to tell you, simple memorization of some given answer will not save you on these questions. As Gail points out, these questions are designed to find out what your actual experience is and most don't have an acceptable canned answer. Craig gave some important recommendations on how to gain that experience.
--Jeff Moden
Change is inevitable... Change for the better is not.