High Availability and Disaster Recovery for Microsoft’s SAP Data Tier: A SQL Server 2008 Technical Case Study

Writers: Joseph Sack, Eric Holling, Sanjay Mishra

Contributors:  Juergen Thomas, Elke Bregler

Technical Reviewers: Prem Mehra, Danny Tambs, Cameron Gardiner, Nicholas Dritsas, Mike Weiner, Lindsey Allen, Denny Lee

Published: October 2010

 

Summary: Microsoft relies heavily on its SAP ERP systems to manage financial, human resources, and supply chain operations. Given the mission-critical nature of these systems, Microsoft IT has established a set of processes and technology solutions that help achieve high availability and also meet disaster recovery requirements. This technical white paper will show how Microsoft IT uses Microsoft SQL Server 2008 functionality to minimize downtime for high business impact SAP ERP applications, as well as minimizing the probability of data loss. SAP ERP uses a three-tier architecture for presentation, application, and data. This white paper will focus on the high availability techniques for SQL Server supporting the SAP data tier.

Whether your organization or company also uses SQL Server with SAP or other SQL Server driven mission critical applications, most of these concepts are applicable to any SQL Server based mission critical application and not limited to just SAP ERP systems. This document will be of interest to database administrators, IT directors, project managers, and infrastructure architects.

 

For more information, please refer to the whitepaper High Availability and Disaster Recovery for Microsoft’s SAP Data Tier: A SQL Server 2008 Technical Case Study.