SOA Research Library

This paper is intended to inform users who are running or planning to deploy remote replication solutions for SQL Server 2005 in an enterprise environment. This paper provides the data needed to understand the options and the limitations for implementing remote replication solutions on a clustered HP server and storage area network (SAN)-based storage infrastructure. Both array-based replication with HP StorageWorks Continuous Access EVA and host-based copying with SQL Server database mirroring are discussed, along with strategies for synchronous and asynchronous replication of SQL databases between primary and remote HP StorageWorks Enterprise Virtual Array (EVA) disk arrays.