TechWeb Digital Library

High Availability for SQL Server 2005 Using Array-based Replication Host-based Mirroring Technologies

Source: HP
Date: April 2008
Type: White Paper
Rating: (1)

Overview:  Array-based remote replication solutions for Microsoft SQL Server have existed for years, and SQL Server 2005 provides a built-in, host-based feature called database mirroring as an alternative for disaster-recovery solutions. Although these technologies are widely available, users may lack the information needed to select the replication, mirroring, or high availability method(s) suitable for their environment; they need information on how to configure the database, storage, and software.

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.


Click here to download now

View all content from this source

Not what you’re looking for? Search again
Go Advanced »
Email Alert

Receive an email alert whenever new content is added to the Hardware section of the TechWeb Digital Library

More Hardware Resources

Modeling the Virtual Data Center
The transition to cloud computing is not simply about outsourcing or applying old technology to new IT processes, it signals a shift in how IT...

Learn how innovative thinking can benefit your data center
In this white paper from The Bathwick Group, courtesy of IBM, you’ll learn the role of innovation in the data center.

More On Hardware