Skip to content

Searching for SQL Server High-Availability solutions?

Proactively prevent the effects of hardware or software failure with SQL Server High-Availability solutions

SQL Server High-Availability Solutions

High-Availability Solutions

DSP wide variety of SQL Server high-availability solutions will help improve the availability of your servers and databases. These solutions disguise the effects of hardware or software failure, further upholding the availability of applications so that downtime for users is minimised.

 

These high-availability solutions include:

  • Always on Failover Customer Instances
  • Always On Availability Groups
  • Database Mirroring
  • Log shipping

Speak to our SQL Server expert today...

Recommended Solutions for Using SQL Server to Protect Data

 

Our recommendations for providing data protection for your SQL Server environment:

  • Data protection through a third-party shared disk solution (a SAN) – Always On Failover Cluster Instances.
  • Data protection through SQL Server – Always On Availability Groups.
  • If running on a version of SQL Server that does not support Always On availability groups, then we recommend using log shipping.

Summary of SQL Server High-Availability Solutions

SQL Server provides numerous options to produce high availability for a server or database. High-Availability options include the following...

Always On Failover Cluster Instances

This service leverages Windows Server Failover Clustering (WSFC) functionality to provide high availability locally through redundancy at the server-instance level—a failover cluster instance (FCI).

An FCI is a lone occurrence of SQL Server installed across WSFC nodes, and, quite possibly, across several subnets. An FCI shows up on the network as an occurrence of SQL Server running on a single computer, but the FCI delivers failover from one WSFC node to another if the current node becomes unavailable.

Database Mirroring

Database mirroring is used to enhance database availability by supporting rapid failover. The service can also be used to uphold a single standby database, or “mirror database”, for a matching production database that is referred to as the “principal database”.

Please Note! If focusing on new development work, we recommend using Always On availability groups instead.

Always-On Availability Groups

Always On Availability Groups is described as an enterprise-level high-availability and disaster recovery solution that was introduced in SQL Server 2012 (11.x). This solution permits you to maximise availability for more than one user database. Always On availability groups that need SQL Server instances reside alongside Windows Server Failover Clustering (WSFC) nodes.

Please Note! An FCI may leverage Always On availability groups to provide remote disaster recovery at the database level.

Log shipping

Similar to Always On availability groups and database mirroring, log shipping also runs at the database level.

Log shipping can be used to maintain more than one warm standby database (referred to as “secondary databases”) for a single production database which is referred to as the “primary database”.
 

DSP Microsoft Customers

EDM logo-1

"Selecting a company like DSP is the best option as you receive a tailored database service. Generalists are not focused on the aspects required.”


Chief Executive Officer | EDM

zopa

"We live and breathe this every day but it was really impressive how quickly DSP got on board with our systems and processes in order to start delivering results from the outset."


Head of Infrastructure | Zopa

brita_logo-1

"Our relationship now is so much more than just client-and-supplier; it is a genuine partnership. It’s more valuable to us as it means we grow and develop as an organisation while working with DSP."


IT Manager | BRITA UK

DSP-Logo-2019-White-600px

 

Contact us Today