SQL Administrator Question:

Tell us on a Windows Server 2003 Active – Passive failover cluster, how do you find the node which is active?

SQL Administrator Interview Question
SQL Administrator Interview Question

Answer:

Using Cluster Administrator, connect to the cluster and select the SQL Server cluster. Once you have selected the SQL Server group, on the right-hand side of the console, the column“Owner” gives us the information of the node on which the SQL Server group is currently active.


Previous QuestionNext Question
Tell me what's your process for troubleshooting database problems?Tell us what are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?