«
»

Ways to Backup/Restore MS Office SharePoint 2007

By Marcello Tonarelli

I did want to share some of the ways to perform backups for the different versions of SharePoint.

Collaborative SharePoint Versions

  • Windows SharePoint Services v2 (WSS v2)
    • Stsadm –o backup –filename [file path & name] –url [http://WSSv2Server] [-overwrite]
      • backups the SharePoint site collection to a known location
    • Stsadm –o restore –filename [file path & name] –url [http://WSSv2Server]
      • restores the SharePoint site collection to a known IIS web application
    • SQL Server 2000 backup/restore of SharePoint content and configuration databases
    • Vendor: Veritas Backup Exec Agent for SQL Server
  • Windows SharePoint Services v3 (WSS v3)
    • Recycle-bin site restore
    • Recycle-bin List/Library restore
    • Recycle-bin List/Document Library item restore
    • stsadm –o backup –filename [file path & name] –url [http://WSSv3Server] [-overwrite]
      • The above backups the SharePoint site collection to a known location
    • stsadm -o backup -directory “[UNC Path]” -backupmethod full -item “farm”
      • The above backups the SharePoint farm to a known UNC path
    • stsadm -o backup -directory “[UNC Path]” -backupmethod full -item “Windows SharePoint Services Web Application”
      • The above backups all SharePoint web applications to a known UNC path
    • stsadm –o restore –filename [file path & name] –url [http://WSSv3Server]
      • The above restores the SharePoint site collection to a known IIS web application
    • stsadm -o restore -directory “[UNC Path]” -restoremethod overwrite -item “farm”
      • The above restores the SharePoint farm
    • stsadm -o restore -directory “[UNC Path]” -restoremethod overwrite -item “farm\Windows SharePoint Services Web Application”
      • The above restores all the SharePoint web applications that is in the farm only
    • SQL Server 2000 backup/restore of SharePoint content and configuration databases
    • Vendor: Veritas Backup Exec Agent for SQL Server

Enterprise SharePoint Versions

  • SharePoint Portal Server 2003 (SPS 2003)
    • stsadm –o backup –filename [file path & name] –url [http://SPS2K3Server] [-overwrite]
      • backups the SharePoint site collection to a known location
    • stsadm –o restore –filename [file path & name] –url [http://SPS2K3Server]
      • restores the SharePoint site collection to a known IIS web application
    • SharePoint Portal Server Data Backup and Restore windows application
    • SQL Server 2000 backup/restore of SharePoint content and configuration databases
    • Vendor: Veritas Backup Exec Agent for SQL Server
    • Vendor: Veritas Backup Exec Agent for SharePoint Portal Server 2003
    • Vendor: AvePoint DocAve 3.0 Backup/Restore application
      • Provides item level backup and restore to a global SharePoint deployment
  • Microsoft Office SharePoint Server 2007 (MOSS 2007)
    • Recycle-bin site restore
    • Recycle-bin List/Library restore
    • Recycle-bin List/Document Library item restore
    • stsadm –o backup –filename [file path & name] –url [http://MOSS2K7Server] [-overwrite]
      • backups the SharePoint site collection to a known location
    • stsadm -o backup -directory “[UNC Path]” -backupmethod full -item “Windows SharePoint Services Web Application”
      • The above backups all SharePoint web applications to a known UNC path
    • stsadm -o backup -directory “[UNC Path]” -backupmethod full -item “SharedServicesProvider”
      • The above backups the Shared Service Provider to a known UNC path
    • stsadm –o restore –filename [file path & name] –url [http://MOSS2K7Server]
      • restores the SharePoint site collection to a known IIS web application
    • stsadm -o restore -directory “[UNC Path]” -restoremethod overwrite -item “farm”
      • The above restores the SharePoint farm
    • stsadm -o restore -directory “[UNC Path]” -restoremethod overwrite -item “farm\Windows SharePoint Services Web Application”
      • The above restores all the SharePoint web applications that is in the farm only
    • stsadm -o restore -directory “[UNC Path]” -restoremethod overwrite -item “SharedServicesProvider”
      • The above restores the SharePoint Service Provider database and index files
    • SQL Server 2000 backup/restore of SharePoint content and configuration databases
    • Vendor: Veritas Backup Exec Agent for SQL Server
    • Vendor: Veritas Backup Exec Agent for SharePoint Portal Server 2003
    • Vendor: AvePoint DocAve 4.0 Backup/Restore application
      • Provides item level backup and restore to a global SharePoint deployment

FYI, to find the stsadm utility in your instance of SharePoint, you must access the SharePoint web server and navigate to “[Hard_Drive]:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Bin”. The executable contains a number of useful operations other than backup/restore for SharePoint. I recommend that the IT administrator get to know some of the other possible operations that can make administrating SharePoint easier. For simply backups, I like to create batch file scripts that contain something like the following: “stsadm –o backup –url [http://MySharePointSite] –filename [\\MyBackupServer\BackupShare\[Mon|Tue|Wed|Thu|Fri]]”. This allows me to ensure that every day of the week there is a backup to disk that I can restore. In addition, best practice tells me to ensure that you have a backup system that always backs up the files to tape. This would allow for restores that is past one week.

There are advantages and disadvantages to each backup method above.

This entry was posted on April 23, 2008 at 8:30 am and is filed under WSS 3.0 e MOSS 2007. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply