Recently organizations, fellow SQL Server MVPs and DBAs have asked me for resources on how to install a SQL Server 2008 Failover Cluster from a Windows Server 2008 perspective. Definitely, failover clustering is a hot topic within the SQL community - specifically if you are trying to obtain high availability and minimize data loss.
My latest title SQL Server 2008 Management and Administration includes a dedicated chapter on how to design and implement a SQL Server 2008 Failover Clustering when running on Windows Server 2008. The chapter includes; the new features associated with failover clustering for both SQL Server 2008 and Windows Server 2008, it then covers step-by-steps on implementing a two node single instance failover cluster and a multiple instance failover cluster. Finally, the chapter also includes steps associated with adding the clustering service and establishing the cluster from a Windows Server 2008 standpoint. I don't believe any other resource including Books Online includes this level of detail - specifically establishing the Windows Server 2008 cluster.
It is worth noting, when running SQL Server 2008 on Windows Server 2008, you can now scale out up to 16 nodes within the cluster. 16 nodes requires the Enterprise Edition of both Windows Server 2008
Cheers
Ross Mistry - SQL MVP
I recently joined twitter - @RossMistry. Feel free to follow the daily events of an Author, Consultant and SQL Server MVP.
----------------------------------------
Ross Mistry, SQL MVP
Author, Consultant and SQL Server MVP
Check out my latest books, blogs and tweets.
Author: SQL Server 2008 Management and Administration and Windows Server 2008 Unleashed
Blog: http://www.networkworld.com/community/mistry
Twitter: http://www.twitter.com/RossMistry
Ross Mistry, SQL Server MVP, MCTS, MCDBA, MCSE, is a principal consultant and partner with Convergent Computing. As a lead architect, Ross focuses on designing and implementing SQL Server, Windows Server, Active Directory, and Exchange solutions for Fortune 500 organizations with a global presence. His specialties include high availability, migrations, security, consolidation and virtualization. Ross has also been involved with many bestselling books, his latest titles authored include SQL Server 2008 Management and Administration and Windows Server 2008 Unleashed. As a SQL Server MVP, Ross assists the global community by freely sharing his knowledge of SQL Server via posting for newsgroups, blogs and speaking engagements around the world. He frequently speaks at Microsoft, SQL Server North American PASS, SQL Server Europe PASS and Dev Connections.
Check out Ross Mistry's latest books:
SQL Server 2008 Management and Administration
Windows Server 2008 Hyper-V Unleashed
Windows Server 2008 Unleashed
SQL Server 2008 Management and Administration was selected as the January, 2009, book giveaway on Microsoft Subnet. Each month, Microsoft Subnet and Pearson Education gives away 15 copies of a hot Microsoft title. Click here to read a chapter excerpt. Click here to enter the monthly book giveaway contest.
The Leader in Network Knowledge
On the subject of load
On the subject of load balancing, why not get the highest availability while not getting caught in high prices? Kemp’s got some great load balancers that are low priced and high in quality:
http://www.kemptechnologies.com/?utm_source=blog&utm_medium=pv&utm_content=zs&utm_campaign=home
Post new comment