Solutions

everRun^® for Microsoft SQL Server

Protecting Just The Database Is Not Enough

Protecting Microsoft SQL Server and its databases is a top priority for many businesses, but it is generally not enough. If the application working in conjunction with SQL Server is not also protected, business operations will be disrupted. All but the simplest database applications include a separate application component that includes business logic, user interface control, and sometimes communication with other applications or networks. Applications may include in-memory data or file system data, in addition to SQL Server data, all adding to the complexity of the high availability protection challenge.

A Better High Availability Alternative Than SQL Failover

everRun software provides high availability protection for both SQL Server and the related applications by preventing:

• Unplanned server downtime and operator errors
• Planned downtime due to reconfiguration, hardware and software upgrades
• Data loss or corruption
• Site failures or disasters

everRun is a great choice for protecting Microsoft SQL Server high availability and related database applications:

• Higher levels of availability than competing failover solutions
• Selectable fault-tolerance using a range of everRun products along with the "availability dial" of everRun VM
• Simple to install and manage with no need for specialized staff experience or training
• Solutions for both virtual and physical environments
• Solutions for local, near distance and long distance availability and data protection
• Choice of either locally-attached or networked storage
• Built-in failover policy eliminates complex policy definition and the potential for policy errors
• Sophisticated error detection is faster and more reliable than simple failover heartbeats
• Cost effective for a wide range of SQL Server environments
• Application transparency allows database applications to be protected along with SQL Server, without the need for failover scripting or other application-specific procedures or knowledge

everRun SQL Server High Availability and Disaster Recovery Protection

Diagram 1 shows SQL Server, along with an ERP application, in a disaster recovery scenario using everRun DR across two extended distance sites. everRun VM is used for local high availability protection as well as to simplify management and reduce cost of the disaster recovery solution. Data is replicated across the two sites in real time using everRun DR. SQL Server disaster site failover is also managed by everRun DR.

SQL Server Availability and Geographic Fault Tolerance Protection

Diagram 2 shows SQL Server, along with a medical application, with high availability protection provided by everRun across two separate sites using the SplitSite option. A pair of servers - one located at the primary site and one at the backup site - protects SQL Server using everRun. A second pair of servers, also split between the two sites, protects the medical application using everRun. The sites are connected using a high-speed network link. The combination of everRun and SplitSite provides all the benefits of everRun local high availability protection while adding high availability protection for site failures and local disasters.

back to top