AlwaysOn HA Group Implementation

Industry: Science Museum

Project Type: Cloud Solutions

Tools Used: Microsoft’s newest offering in high-availability (HA) AlwaysOn Availability Groups for SQL

The Benefits

Hundreds of Hours Saved

by avoiding database server failures.

Continuous Customers Sales

as applications keep functioning during a failover.

Dollars Saved

as IT staff supports the solution on their own.

“This looks great! Thank you so much for implementing this for us, and writing so well about what needed to be done. I found this documentation very clearly written, concise and yet extremely thorough in what you needed to pass on to us bystanders for future reference.”

- IT Director

Project Overview

A large regional science museum needed to decommission its dedicated offsite disaster recovery (DR) site to leverage cloud-hosted DR services. They needed a robust solution in place for managing the enterprise data and for designing database-level DR processes.

Goals

Cloud-based disaster recovery so data is always available.

Application and associated jobs need to function when transitioned from primary to secondary servers.

Minimal data loss in the event
of a disaster.

Approach

Designed and developed state-of-the-industry database DR processes, including the implementation of cloud-hosted offsite database backups.
Designed and deployed AlwaysOn Availability Groups for SQL Server.
Built custom scripts, SQL agent alerting, and failover procedures to manage the enabling/disabling of read/write required jobs whenever AlwaysOn replica roles change from primary to secondary.
Created a custom process to synchronize database server logins across the replicas.
Designed and implemented a custom solution for managing database backup, index maintenance and integrity checks.

The Results

A data environment that is always on even when server problems arise.

Log backups went from every hour to every minute, keeping data loss and downtime to a minimum.

The solution reduced backup AND index processing time by 50% while offering consistent health check monitoring.

Thorough solution documentation so it can be supported by the science museum IT staff.

Improve Your Performance and Profitability Today

SCS uses best-in-class tools to deliver database, reporting and data platform and analytics solutions. We partner with your team to develop custom solutions.

Get Started

Case Study: