Transcript
SQL Server High Availability and Disaster Recovery
To reduce or eliminate the need to any planned or unplanned downtime in a database, are to of the most important responsibility of any DBA [database administrator]. 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.
A report from 2012 Aberdeen group shows mid-sized enterprises spend around $74,000 per hour in downtime costs and average of $880,600 per year.
In our recent survey, we asked respondents if they have a high availability or disaster recovery plan for their databases. 70% responded yes, and 30% responded no.
SQL Server High Availability
High availability is about providing service availability and 1005 uptime through redundant and fault-tolerant components at the same location.
- Goal: Service availability
- Process: Most likely automatic
- Infrastructure: Single location
- Intention: Retaining service
Common Solutions:
- Failover Clustering
- Synchronous Database Mirroring
- AlwaysOn Availability Groups
Disaster Recovery in SQL Server
Disaster recovery is about providing service continuity and minimizing downtime through redundant and independent site in a distinct location.
- Goal: Service continuity
- Process: Most likely manual
- Infrastructure: Two+ locations
- Intention: Retaining data
Common Solutions:
- Asynchronous Database Mirroring
- AlwaysOn Availability Groups
- Log Shipping
- San-based/Virtualization Replication
Types of SQL high-availability solutions
- 55% use failover clustering
- 23% use database mirroring
- 11% use replications
- 11% use log shipping
Survey says: What type of high availability solution do you use for your SQL Server database? Failover clustering 55%, database mirroring 23%, replication 11%, and log shipping 11%
For more information, please refer to Webcast: Geek Sync: Are AlwaysOn Availability Groups Right for You? .
See Also:
Topics : Database Diagnostics,Database Monitoring,Database Performance,IT Infrastructure Monitoring,
Products :
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?
SQL Server 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 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 →
