July 19, 2007 08:19 PM

SQL Server 2005’s High Availability Options

Rating: (0)
SQL Server Magazine
InstantDoc ID #96237
You'll find an embarrassment of riches when it comes to SQL Server 2005's high availability options. Choosing the right option really depends on your organization's needs.

To jumpstart your decision process, let's get an overview of what SQL Server 2005 offers.

4. Windows Server Clustering
Microsoft's primary high availability technology for SQL Server 2005, Windows Server Clustering, provides automatic failover in the event of SQL Server system ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Hi rtrivera,
Thanks for your feedback. If you're looking for more information about the high-availability options that Mike discussed in his article, the following are a few SQL Server Magazine articles on these topics:

For more information about SQL Server 2005's high-availability options:
"Putting Together Your High Availability Puzzle," http://www.sqlmag.com/Article/ArticleID/49037/sql_server_49037.html

For more information about clustering:
"Clustering Plus Data Replication Equals Disaster Recovery," http://www.google.com/search?source=ig&hl=en&rlz=&q=%22clustering%22site%3Awindowsitpro.com

For more information about database mirroring:
"A Practical Approach to Database Mirroring," http://www.sqlmag.com/Article/ArticleID/95293/sql_server_95293.html

"Should You Choose Database Mirroring?" http://www.sqlmag.com/Article/ArticleID/95294/sql_server_95294.html

For more information about replication:
"SQL Server 2005 Replication," http://www.sqlmag.com/Article/ArticleID/94413/sql_server_94413.html

"Database vs. Storage Replication," http://www.sqlmag.com/Article/ArticleID/49655/sql_server_49655.html

I hope these resources help.

Megan Bearly
Associate Editor, SQL Server Magazine
mbearly@sqlmag.com

meganbearly 3/24/2008 4:03:10 PM


Good, short and to the point. Now you need to expane on each method.

ERIC2/28/2008 11:10:50 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS