SQL Server High Availability Solutions

High Availability is a critical consideration for SQL Server (or any database platform) because it is a matter of when, not if, a problem will occur.  However, in today’s environment, many systems need 24/7 (or close to it) uptime.  On top of the unplanned downtime is planned downtime – scheduled interruptions for Upgrades/Patching and Maintenance.

Since both planned and unplanned downtime need to be accounted for, SQL Server users need to consider these High Availability options:

  • Failover Clustering
  • Database Mirroring
  • Log Shipping
  • Replication

Each of these solutions has its appropriate usage and complexities.  Let Ntirety, the Database Experts, help to design, deliver and maintain your SQL Server High Availability solution.