- 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.
-
Find More On : - http://www.sqlserver-training.com/250-sql-queries-interview-question-answers/-#5+ SQL Queries Interview Questions ...
-
ERROR: report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the o...
-
http://technet.microsoft.com/en-us/library/cc731002(WS.10).aspx#BKMK_requirements How accounts are created through wizards in ...
