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


Click here to download now

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.

Not what you're looking for? Search again
Go Advanced »
More From the Hardware Section

View All Categories

Business Intelligence : Analytics, Business Process Management, Content management, Dashboards, Data Mining, Performance Management, Databases, Datamarts/Data Warehouses, Information Management, Knowledge Management, Data Quality

Development : Open Source, Windows/.NET, Web Development, Security, Mobility, Java, High Performance Computing, Embedded Systems, Development Tools, Database, Architecture & Design, C/C++

Government : Cloud/SaaS, Leadership, Information Management, Federal, Mobile & Wireless, State & Local, Enterprise Applications, Security, Policy & Regulation, Enterprise Architecture

Hardware : Virtualization Hardware, Windows Servers, Utility/On-demand Computing, Unix/Linux servers, Supercomputers, Peripherals, Macintosh, Handhelds/PDAs, Grid/Cluster Computing, Desktops/PCs, Data centers, Blades, Processors

Healthcare : Interoperability, Administration systems, Clinical information systems, Electronic medical records, The Patient, Security & Privacy, Leadership, Policy & Regulation, Mobile & Wireless

Infrastructure : ATM, Ethernet/Gigabit Ethernet, Frame relay, IPv6, Traffic Management, Network/Systems Management, PBXs, Printers, Remote Access, Routers, Switches, UPS, VPNs, WAN Optimization/Acceleration, Wide Area File Services

Internet : B2B, B2C, Browsers, E-Business/E-Commerce, E-retail, Google, Social Business, Internet Security, Search, Social Networks, Traffic Reporting/Monitoring, Web 2.0, Web Development, Internet Policy

Management : Career Development, Training, Small-Medium Business, Salary/Compensation, ROI/TCO, Regulation/Compliance, Recruiting, Personnel Management, Outsourcing, Legal, H-1B, Executive Insights/Interviews, Workplace Trends

Mobility : WLAN, Wireless Security, Wi-Fi/WiMax, Wi-Fi VOIP, Smartphones, 3G Wireless/Broadband, Muni Wireless, Mobile Messaging, Mobile Business, Fixed Mobile Convergence, 802.11x, RFID

Personal Tech : Blackberry, Bluetooth, Bluray, Digital Cameras, Digital Music, Digital Rights Management, Virtual worlds, iPhone, iPod, Peripherals, Smartphones, TVs/Home Theater, Global Positioning Systems

Security : Security Administration, End user/Client Security, Encryption, Cyberterror, Attacks/Breaches, Application Security, Antivirus, NAC, Perimeter Security, Privacy, Vulnerabilities and Threats, Storage Security, Intrusion Prevention

Services : Telecom/Voice Services, Business Process Outsourcing, Business Services, Disaster Recovery, Systems Integration, Hosted Storage, Internet/Data Services, Outsourcing, Software as a Service, Hosted Applications

Software : Web Services, Service Oriented Architecture, Server Virtualization, Productivity Applications, Operating Systems, Open Source, Linux, Hosted Software/Applications, ERP, Development Tools, Databases, Database Applications, CRM, Business Systems Management, Integration, Application Optimization

Storage : Data protection, Disaster Recovery, Removable/Portable Storage, Security, Storage Fabrics, Storage Systems, Virtualization

Telecom : VOIP, Unified Communications, Voice services, PBXs, Internet policy, Presence, Collaboration Systems, Business, Regulation, Call Centers

Windows/Microsoft : Applications, Internet Explorer, Microsoft Company News, Security, Open Source, Operating system, Office Suite

More Hardware Resources

The Tactical Realities of Building a Virtual Desktop Infrastructure
By leveraging HP technology, powered by Intel, Insight enhances your IT infrastructure's agility, scalability and deployment times. Learn how in The Tactical Realities of Building ......

Audio Series: The Evolution of LAN Bypass Technology: Lanner's Generation One to Generation Three Bypass
Lanner refers to the advances in LAN bypass technology as Generation One, Generation Two and Generation Three, and this whitepaper explains the evolution of this technology.

Like ITBreak on Facebook

More On Hardware