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.
About Nicholas Dritsas
Nicholas Dritsas has been working with SQL Server and Business Intelligence for the past 11+ years as part of Microsoft Consulting Services and SQL Server Product Group. In his time at MCS, he acted as a Lead Architect to a number of Fortune 500 SQL Server and BI implementations, including Hilton Hotels, Nestle USA and Walt Disney. Since 2006, he joined the SQL Server’s Customer Advisory Team working with the largest and most complex SQL Server and BI projects in Asia. Nicholas has presented numerous times in internal and external events and conferences around BI subjects and best practices.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|
