News

Thursday, December 11, 2008

SQL Server Magazine Focus: Planning and Implementing a SQL Server Cluster

    SQL Server Magazine
The #1 SQL Server Resource
The following in-depth article is the focus story of the latest issue of SQL Server Magazine--available only to current subscribers. This article is being made available to non-subscribers for a short time. If you aren't already a subscriber, now is the time to sign up to gain access to every article ever published in Windows IT Pro!

Planning and Implementing a SQL Server Cluster

Servers and systems have outages—it’s a fact of life in IT. Clustering SQL Server instances gives us a measure of protection against these failures. Even in well laid out environments in which web and application servers have redundant backups, the SQL Server system is usually just sitting there as a single point of failure, despite taking the longest time to repair and restore. (Getting a database server set up and the database restored to it from tape will take several hours or days, depending on the speed of the restore and the size of the database.) You can avoid hardware and application downtime by setting up a SQL Server cluster in your environment. In this article, I’ll explain how clustering works and the hardware and software that’s needed to create a SQL Server cluster. In addition, I’ll show you how to create a failover cluster using SQL Server 2005 and Windows Server 2003 Enterprise Edition.

[...]

Read the rest of this article

Subscribe to SQL Server Magazine

You won't want to miss SQL Server Magazine in 2009! Subscribe today and plug yourself into the #1 SQL Server resource for building world-class applications. Along with loads of how-to articles, time-saving advice, and expert tips & solutions, you'll get the latest SQL Server 2008 System Views Poster FREE with your paid order.

No comments:

Blog Archive