Almost all organisations rely on data, be it in the form of files or databases. The most challenging aspect of managing data for any organisation is high availability and disaster recovery. For most companies, downtime is more than just an inconvenience. Indeed, when a business’s applications aren’t available, there is an immediate loss of productivity which can impact the company's bottom line. In addition to the monetary loss, when applications and services are unavailable, there is the possibility of loss of customer confidence and company reputation.

We took a 5-step process to dismantle the existing system and homogeneously put it back together:
1.    Complete Database backup 
2.    Dropped Databases from existing availability group 
3.    Restored Full backups with no recovery in Secondary Node
4.    Database Differential Backups and Restored with no recovery 
5.    Database Log Backups and Restored 

Our client, a major million-dollar logistics company in US, had employed Microsoft SQL servers to handle their numerous SharePoint sites. The essential requirement for such application is uninterrupted availability, data backup and restore. The snowballing of demands meant that during test phases and regular maintenance audits, failover was a challenge.  The client chose us as their partners to advice on technologies that could be used to minimize downtime and maximize data protection so that continuous access to business-critical data is available. As with most applications, to facilitate availability, overall sound architecture and resilience that can endure unforeseen anomalies, a lot of planning and consideration was required.  We presented several viable options to the client. A high availability strategy was an essential requirement for a production SharePoint Server environment. After carefully studying the pros and cons of each solution suggested, the AlwaysOn Availability Groups feature was chosen without incurring any additional licensing costs. AlwaysOn enhances the existing technologies of database mirroring and failover clustering to provide a stable layer of high availability and disaster recovery that minimizes Recovery Point Objective (RPO) and Recovery Time Objective (RTO).

The marriage of high availability and disaster recovery in a single framework now makes this system one of the most unfailing solutions in its class. Some tangible business benefits include:

  • Minimized failover time – Reduced up to 20 seconds of downtime, less than 1 hour for a year
  • Saved $300,000 or more of impact – Failure prevention of a business-critical application
  • Real-Time reports – Real-time actionable insights and reports from the SQL servers.
  • Relaxed bandwidth usage – Efficient utilization of bandwidth resulting in decreasing infrastructural congestion
  • Maintenance contract acquired – Delighted clients consequential in successive agreements for maintenance. 

When you are not compelled to choose a specific commit mode, the AlwaysOn availability groups can offer you robustness to deal with high availability scenario while providing you the flexibility to tackle a recovery scenario where servers are located remotely. Business continuity management is a sequence of current and interlocking directives. When done correctly, it aligns with a firm's strategic priorities and could help to mitigate risks and meet regulatory requirements.