Achieve Microsoft SQL Server High Availability with data replication

This sample chapter, taken from Sams' Microsoft SQL Server High Availability, discusses how you can use data replication as a high availability solution.

Data replication is a powerful feature of SQL Server that can be used in many business situations. Learn how to use data replication as a high availability solution.

This sample chapter, taken from Sams' Microsoft SQL Server High Availability, provides an in-depth discussion about data replication. The chapter covers the following topics:

• Data replication and high availabiltiy
• The publisher, distributor, and subscriber metaphor
• Replication scenarios for high availability
• SQL Server replication types
• Planning for SQL Server data replication
• Building up replication
• Scripting replication
• Failing over to a warm standby subscriber
• HA scenario and replication

Title: Microsoft SQL Server High Availability
ISBN: 0672326256
Published: November 2004
Author: Paul Bertucci
Chapter: Chapter 7: Microsoft SQL Server Data Replication
Published by Sams Publishing