High Availability and Disaster Recovery

SQL Server High Availability and Disaster Recovery

To reduce or eliminate the need for any planned or unplanned downtime in a database, are two of the most important responsibilities of any DBA. More and more businesses are realizing the importance of an investment in high availability to improve their operational performance and to reduce the impact of downtime when a disaster happens. But what are High Availability and Disaster Recovery exactly?

High Availability (HA) is about providing service availability and 100% uptime through redundant and fault-tolerant components at the same location. Disaster Recovery (DR) is about providing service continuity and minimizing downtime through redundant & independent site in a distinct location. Commonly Solutions for HA/DR are failover clustering, database mirroring, always availability groups, log shipping, and replications.

A report from 2012 Aberdeen group showed mid-sized enterprises spend around $74,000/hr. in downtime costs, an average of $880,600/yr. In our recent survey, 70% of the respondents said they have some sort of HA/DR for their SQL Server database, while 30% said they don’t have any. Learn More at →

Start a FREE Trial of SQL Diagnostic Manager
Share This
Contact IDERA:
+1 (713) 523-4433