What We Faced

Challenge

A North American Utility needed to deploy a high-availability SQL environment. ​

MRE Consulting was tasked with installing, configuring, and managing the solution.

Implemented Technologies

Microsoft SQL Server 2012
SQL Server AlwaysOn
Microsoft Hyper-V​
What We Did

Solution

Microsoft’s SQL Server was selected as the best-fit solution because it provided required uptime and data protection. The integrated, high-availability disaster recovery solution, SQL Server AlwaysOn, would also help reduce planned and unplanned downtime. ​

To meet the requirements of the project while managing costs, MRE designed and implemented a system utilizing Microsoft’s Hyper-V technology to virtualize the SQL Servers. ​

MRE then configured the SQL servers in an AlwaysOn Availability Group. To meet the client’s need for a disaster recovery site, MRE devised a custom integrated log shipping solution.

What We Delivered

Results

The resulting environment supported over 10,000 users, was redundant and featured a disaster recovery site that replicated the data entered into SQL Log Shipping. ​

MRE Consulting continued to manage the environment through its managed services. Monitoring utilizes automated maintenance plans and alerting systems.

Benefits included:​
  • Fully redundant hardware and applications​
  • Automatic failure detection and failover configurations​
  • No single points of failure​
  • Scalable, easy-to-manage environment

Let's Talk

Headshot of MRE Employee Todd Walker

Todd Walker

Director, Custom Development
Connect

Kicking Off Your Next Project?

  • Hidden