SQL Server & Database Replication & Offsite Backup
Microsoft SQL Server is a robust database application that is utilized by hundreds of thousands of organizations all over the world. In the event of a disaster or logical failure that impacts the availability of Microsoft SQL Server it can result in data loss, significantly reduced employee productivity and even damage a company brand and share price making BC/DR extremely important to organizations of all sizes.
Challenges of Protecting Microsoft SQL Servers
Protecting Microsoft SQL databases is challenging as transactions are written quickly and constantly with high rates of change. Many organizations use log shipping, application based or storage based replication as a protection technologies for BC/DR which translates to a complex and manual recovery processes that requires the knowledge of individuals increasing risk. In addition to this complexity, just getting the data to the recovery site can be challenging. If the data is not compressed then it may saturate the WAN link, if the write-order fidelity is not maintained the database will be in an inconsistent state and many protection technologies don’t allow clear visibility of the protection status and management of SLAs for the protection.
Additionally, Microsoft SQL Databases usually form part of an enterprise multi-VM application comprising several VMs with potentially terabytes of associated data, making it difficult to ensure an entire application can be recovered consistently. If the group of VMs is not recoverable to the same point in time, a lengthy, manual recovery is required, further damaging the business.
Benefits of protecting Microsoft SQL Server using Zerto Virtual Replication
By simply selecting the Virtual Machines (VMs) that host Microsoft SQL Server for protection, Zerto Virtual Replication enables robust, enterprise-class BC/DR that delivers Recovery Point Objectives (RPOs) of seconds, Recovery Time Objectives (RTOs) of minutes with advanced features for handling the protection of highly transactional databases. No complex application integration is required for Zerto Virtual Replication to protect Microsoft SQL Servers as all of the replication is done in the hypervisor making it simple and scalable with the following features:
- Hypervisor integrated simple centralized management with clear visibility on protection status, KPIs and SLAs
- No configuration changes to SQL required to configure protection
- RPOs of seconds with no snapshots and no performance impact
- Point in time recovery to increments every few seconds up to 14 days in the past maintaining write-order fidelity on all SQL database writes removing the need for log shipping
- No SQL knowledge required for failover or point in time recovery
- SQL VSS writer integration for scheduling application consistent points in time
- TempDB initial replication, without subsequent change, saving 50% of replication traffic
- RTOs of minutes with boot ordering and automatic IP reconfiguration
- Consistent multi-VM application recovery with Virtual Protection Group (VPG) technology
- No-impact failover testing with no break in replication or shutdown in production
- Failover test SQL with application servers in isolated bubble networks
- No live VM running the recovery site reducing DR site overheads and complexity
- Failover is user initiated removing potential for false positive failovers
- Protect Physical or Virtual Raw Device Mappings (RDMs) to virtual disks or pre-provisioned RDMs in the target site
Finally, ZVR’s Offsite Backup feature uses information replicated for DR purposes and leverages it for backup, which helps to reduce the strain on production workloads.
Many businesses rely on Microsoft SQL Server and if the database is not available productivity and revenue are impacted or worse, a company’s hard-earned reputation and brand. Zerto Virtual Replication leverages continuous, block-level replication that has been purpose-built to maintain the data integrity of rapidly changing databases while minimizing data loss. Through automation of failover, failback and DR testing, aggressive service levels are realized with RPOs of seconds and RTOs of minutes all while maintain data integrity.