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

SharePoint Backup and Restore – Prepare for the worst … - PowerPoint PPT Presentation


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

SharePoint Backup and Restore – Prepare for the worst …

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 …

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

  • SSODB (Single Sign-on Database)

  • Selected virtual servers/site collections


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

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

PORTAL

IIS METABASE

VIRTUAL SERVER DIRECTORIES

BACKUP

RESTORE


Demo

Portal Restore


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

  • 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

  • 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

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


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

  • 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

  • IIS metabase

  • Root directories of WSS-extended virtual servers

  • Custom web part assemblies

  • Custom templates

  • Addin software


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