MSSQL Interview Question Clustering- Part1

Will Indian Rupee Cross 55??

Cluster environment is prevalent not only in big organizations but also medium and small. This is observed that in "Sql Server DBA Interview" the interviewer tests candidates with cluster questions. You will always be in the good books of your interviewer if you know at least basic info about cluster.

Q1-  What is the status of services on passive node for failover cluster in SQL server?
Ans - SQL services will be in manual and stopped. Cluster service will be in automatic and started mode on both the nodes.

Q2- Can you move the resources after pausing the node?
Ans - Yes resources can be moved after pausing the node. But we can't move them back till the node is paused.

Q3-  Where is the prevent failback option?
Ans - This is the resource group property. It doesn't allow the resources to move back to the preferred node once the node is ready to take the connections after failover.

Q4 - How does the failover happen? What checks are performed to ensure that another node is up?
Ans -
LooksAlive - The node which host the SQL server resources is verifed whether this node (server) is up
IsAlive - The node which host the SQL server resources is verifed whether the SQL service is up or not. Basically running SELECT @@SERVERNAME
Q5 What will happen if you try to start the fultext service on the passive node.
Ans: This can be started on both the nodes as this doesn't have any dependecy on SQL service or any resource which is possessed by active node.

Reader of This blog also showed their interest in following blogs:
  1. SQL Server DBA “Interview Questions And Answers”
  2. SQL Azure Interview Questions and Answers Part – 1
  3. SQL Azure Interview Questions and Answers Part – 2
  4. Powershell Interview Questions and Answers
Along with technical learning I would like to share some great articles for anyone interested in the betterment of his/her family life



  1. Resources like the one you mentioned here will be very useful to me! I will post a link to this page on my blog. I am sure my visitors will find that very useful.


Post a Comment

Popular posts from this blog

Understand Query Execution Plan- Index Scan, Index Seek And Key Lookup

DBCC CheckDB The operating system returned error 21(The device is not ready.)