Data protection and recovery for Microsoft® Office SharePoint® Server 2007
Bruno Lanceleaux and the Office SharePoint Server 2007 Product Team
This paper describes content recovery, site recovery, and disaster recovery strategies for Office SharePoint Server 2007 deployments.
The Microsoft OfficeSharePoint Server Content Publishing team thanks the following technical reviewers on this paper:
• Ivan Wilson, SharePoint MVP, http://guru-web.blogspot.com/
• Ben Curry, SharePoint MVP, http://mindsharpblogs.com/Ben/
• Bob Fox, SharePoint MVP, http://bobfox.securespsite.com/FoxBlog/default.aspx
• Joel Oleson, http://www.sharepointjoel.com/default.aspx
• Gabe Bratton,SharePoint Supportability Program Manager, Microsoft
• Samer Sawaya, Program Manager, Microsoft
• Nakul Joshi, Senior Consultant, Microsoft India
• Steve Peschka, Lead Architect, Microsoft
• Troy Starr, Tester, Microsoft
• Patrick Simek, Developer, Microsoft
• Scott St. Jean, Program Manager, Microsoft SharePoint Online
The information contained in this documentrepresents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.
This White Paper is for informational purposes only.MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical,photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not giveyou any license to these patents, trademarks, copyrights, or other intellectual property.
© 2009 Microsoft Corporation. All rights reserved.
Microsoft, InfoPath, SQL Server, SharePoint, Windows, and Windows Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
Table of Contents
Executive summary 1
Levels of datarecovery in Office SharePoint Server 2007 1
Solutions for data recovery 1
Content recovery 2
Recycle Bin 3
Site recovery 4
Office SharePoint Designer 2007 6
Microsoft IT Site Delete Capture feature 1.0 (Web Delete event) 6
SQL Server database snapshots 7
Disaster recovery 7
Office SharePoint Server components 7
Binary files 8
Customizations 10Content 11
Microsoft tools for backing up and recovering Office SharePoint Server 11
Office SharePoint Server built-in backup and recovery tools 13
SQL Server backup and recovery 16
Microsoft System Center Data Protection Manager 2007 17
Windows Server Backup 18
Components and backup tools 18
Planning your disaster recovery strategy 22
Determine likely recovery scenarios 22
Recommended backupstandards 22
Recommended recovery environment 24
How to perform content recovery, site recovery, and disaster recovery tasks 24
Content recovery 24
Recycle Bin 25
Site recovery 27
Use Office SharePoint Designer 2007 to back up a Web site 27
Use Office SharePoint Designer 2007 to restore a Web site 28
Use Microsoft IT Site Delete Capture 1.0 to capture and restore...