SQL Server Customer Advisory Team - SQL Server Best Practices

Whitepapers

Using Replication for High Availability and Disaster Recovery

Nicholas Dritsas

22 Sep 2009 12:29 PM

Comments 9

Writers: Manaphan Huntrakoon, Nicholas Dritsas

Technical Reviewers: Burzin Patel, Sanjay MishraPublished: August 2009 Summary: An essential part of IT mission is maintaining high availability and disaster recovery capability. This technical case study shows how a company can use SQL Server 2008 database replication to eliminate single points of failure in data centers, and to enable fast recovery from a possible disaster at its primary data center. These strategies and solutions will be of interest to database administrators, senior IT managers, project leads, and architects.Introduction: An international company has deployed a number of SQL Server instances spread out over different locations in Asia, the United States and Europe. The main problem they wanted to resolve was the high availability of data critical to their main application. In the event this data ever became unavailable, the financial repercussions would have been substantial. While the company had many ways and methods to alleviate this problem, they were unsure of which SQL Server high availability/disaster recovery technology would address their problem plus provide a strategic platform for the future. They engaged with Microsoft to help in the design of an architecture best fit for their needs, budget, expectations and skill set. In this document, we will be going through the steps and processes the project team went through to evaluate and decide on the best choices and options.
For more details, please look in this white paper: Using Replication for High Availability and Disaster Recovery in SQL Server 2008.

Availability, Replication, SQL Server, SQL Server 2008, Other

Your comment has been posted. Close

Thank you, your comment requires moderation so it may take a while to appear. Close