Ads

Showing posts with label SQL Cluster 2008 Differences. Show all posts
Showing posts with label SQL Cluster 2008 Differences. Show all posts

13 September 2012

Easy Notable Differences in 2008 SQL Cluster



  • Up to 8 nodes in SQL Server 2005, 16 nodes in SQL Server 2008.
  • No remote execution on the cluster nodes. We can now upgrade or patch a cluster with minimal downtime. Updates and service packs must be apply on each node separately; setup must be executed on each node. The same to add a new node, setup must be executed on each node.
  • Service packs can now be uninstalled.
  • SQL Server 2008 are not supported on WOW mode.
  • MSDTC was required as a cluster resource to install SQL Server 2000 and SQL Server 2005 clusters. SQL Server 2008 does not have that requirement anymore to install a cluster.