Sharepoint backup and restore prepare for the worst
Download
1 / 15

SharePoint Backup and Restore - PowerPoint PPT Presentation


  • 774 Views
  • 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

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

PowerPoint Slideshow about 'SharePoint Backup and Restore ' - 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
Agenda

  • 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

IIS METABASE

VIRTUAL SERVER DIRECTORIES

BACKUP

RESTORE


Portal restore l.jpg

Demo

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
SPSBackup

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

    http://msdn.microsoft.com/msdnmag/issues/05/02/RecycleBinforWSS/

  • Deleted items document library

    http://mindsharpblogs.com/todd/archive/2005/10/06/719.aspx

  • SharePoint Recycle Bin

    http://www.gotdotnet.com/Workspaces/Workspace.aspx?id=8437a203-f377-401c-b23d-ae59e6f05b80


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
Resources

  • Be Prepared a guide to SharePoint Disaster Prevention and Recovery http://www.microsoft.com/technet/technetmag/issues/2005/11/BePrepared/default.aspx

  • Backup and Restore Options for Windows SharePoint Services

    http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsf20.mspx

  • 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)

    http://www.msd2d.com/Content/Tip_viewitem.aspx?section=Sharepoint&category=Administration&id=425b6c89-886e-4f94-98ee-2a90d57cfdf7


ad