SQL Administrator Question:

Tell us what are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

SQL Administrator Interview Question
SQL Administrator Interview Question

Answer:

On SQL Server 2005, installing SQL Server failover cluster is a single step process whereas on SQL Server 2008 or above it is a multi-step process. That is, in SQL Server 2005, the Installation process itself installs on all of the nodes (be it 2 nodes or 3 nodes). In 2008 or above this has changed, we would need to install separately on all the nodes. 2 times if it is a 2 node cluster or 3 times in a 3 node cluster and so on.


Previous QuestionNext Question
Tell us on a Windows Server 2003 Active – Passive failover cluster, how do you find the node which is active?Do you know what is the importance of a recovery model?