SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.

Whitepapers

Configure disaster recovery across SharePoint farms by using SQL Server log shipping

Contributors / Technical Reviewers: Doron Bar-Caspi, Lindsay Allen, Sanjay Mishra, Burzin Patel, Bill Baer, Cory Burns, Steve Peschka, JP Poissant

Published: May 2009

 

This article describes how to use Microsoft SQL Server 2005 or Microsoft SQL Server 2008 log shipping to create a disaster recovery farm in a geographically distributed data center for Microsoft Office SharePoint Server 2007 with Service Pack 2 (SP2). By using this configuration, you can provide a disaster recovery site that provides current search results when a failover occurs. The article assumes that you are familiar with the concepts and terms presented in Plan for availability (Office SharePoint Server).

It often takes many teams or roles in an organization to create and configure a secondary data center and farm. In order to configure and test the secondary environment, you need to confer with the administrators of the authentication providers, the SQL Server database administrators, and all affected SharePoint farm administrators. This article is intended primarily for SharePoint farm administrators to help them do the following:

  • Understand the requirements for creating log-shipped disaster recovery farms
  • Set up trial log-shipped environments
  • Communicate with the SQL Server database administrators who will configure log shipping for the production environments.

For more information, please refer to the whitepaper Configure disaster recovery across SharePoint farms by using SQL Server log shipping.

Comments

No Comments
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
Copyright 2008 Microsoft Corporation. All Rights Reserved.