Sharepoint backup and restore prepare for the worst
1 / 15

- PowerPoint PPT Presentation

  • Updated On :

SharePoint Backup and Restore – Prepare for the worst …. Marc Pollentier, Phoenix Solutions Joris Poelmans, Dolmen. Agenda. Backup, Restore Demo Document, attachment recovery Undelete – different options Resources. What Gets Backed Up?. All SQL databases Index files and sps.edb

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about '' - Solomon

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Sharepoint backup and restore prepare for the worst l.jpg
SharePoint Backup and Restore – Prepare for the worst …

Marc Pollentier, Phoenix Solutions

Joris Poelmans, Dolmen

Agenda l.jpg

  • Backup, Restore

  • Demo

  • Document, attachment recovery

  • Undelete – different options

  • Resources

What gets backed up l.jpg
What Gets Backed Up?

  • All SQL databases

  • Index files and sps.edb

  • SSODB (Single Sign-on Database)

  • Selected virtual servers/site collections

What should be backed up separately l.jpg
What Should Be Backed Up Separately?

  • All customizations such as templates, web part Files, and other file-based information

  • Operating system and binaries

  • System State Data

  • IIS, Virtual Servers and Metabase

Three steps to a full farm backup l.jpg
Three Steps to a Full Farm Backup

  • First, backup your portals, including the Index

    • Using SQL Server + File System will not adequately backup the index due to the index files’ connection to sps.edb

  • Second, backup the IIS Metabase on each Web Server

  • Third, backup the virtual server files for each virtual server

Last slide before demo l.jpg
Last slide before demo!






Portal restore l.jpg


Portal Restore

Portal restore restore w databases l.jpg
Portal RestoreRestore w/ Databases

  • Restoring DB from Databases w/ Central Admin

    • Click - Create a portal site

    • Choose - Restore a portal site

    • Select Servers and databases

    • Choose Virtual Server and specify URL

    • Extend and Map as needed

  • Use SPSBackup to restore index & Legacy Doc Lib

  • Gotchas:

    • Same Portal Topology Required

      (Child vs. Full)

    • Portal may not be in the same farm twice even with different name (use standby)

    • Same version, same SP, Hotfixes, etc..

What to backup l.jpg
What to Backup

  • SharePoint SQL Databases

    • Config, Content, Prof & Serv Databases

  • SharePoint Server(s) Drives & System State

    • IIS Metabase

    • Web Part Packages (Assemblies)

    • IIS Home Directories & VDirs

    • Program Files & Common File Customizations

  • Portal Web Stores

    • SPS Indexes (Jet db) & Legacy Doc Libraries

Sharepoint backup restore tools l.jpg
SharePoint Backup/Restore Tools

  • SPSBackup – Full SPS 2003 Backup

  • Native SQL Backup – SQL db backup

  • STSAdm – WSS Site Collection Backup/Restore

  • Smigrate – WSS Upgrade and Site & Sub site Migration Tool

  • SPBackup – SharePoint ResKit automate Site Collection Backup

  • SharePoint Database Explorer – SharePoint Reskit restore file from Database

  • TextCopy – SQL tool to copy blob from db to disk

  • Third Party or Partners- AvePoint, CommVault, CA, Veritas etc…

Spsbackup l.jpg

Full Farm Backup

Spsbackup.exe /all /file <Backup path and file>

Central Portal Index Backup example:

Spsbackup.exe /portal http://portal /service index /file \\server\share\backup /overwrite

  • Databases

  • Legacy Doc Lib

  • SPS Indexes

  • XML manifest

    • schema version

    • portal GUID

    • Path to DB backup file

    • Result

      * Most common issues are write permissions on destination for service account or conflict with other SharePoint jobs

Database backup optimization l.jpg
DatabaseBackup Optimization

  • Database sizes

    • 25GB Database Storage (>250 sites)

    • Number of databases (>300)

  • Cost Savings

    • Direct to Media or Cheaper Disks?

    • DB Backup compression

  • Snapshots, Clones, Volume Mirroring

Undelete options l.jpg
Undelete options

  • Add a recycle bin to Windows SharePoint Services

  • Deleted items document library

  • SharePoint Recycle Bin

Backup your frontend webservers l.jpg
Backup your frontend webservers

  • IIS metabase

  • Root directories of WSS-extended virtual servers

  • Custom web part assemblies

  • Custom templates

  • Addin software

Resources l.jpg

  • Be Prepared a guide to SharePoint Disaster Prevention and Recovery

  • Backup and Restore Options for Windows SharePoint Services

  • SharePoint Resource Kit – Chapter 28 : Disaster Recovery in SharePoint Products and technologies

  • MSD2D: Backing up Sharepoint Portal Server 2 (by James Edelen). (5/2/2003)