Thursday, May 18, 2006

Sharepoint Backup strategies

There are several ways to backup your Sharepoint environment. Depending if you have a complete Portal installation or just Windows Sharepoint Services. After reading the Disaster Recovery in SharePoint Products and Technologies we came to the following conclusion for our scenario: - STSADM Backup your sites with stsadm - SPSBACKUP Backup your configuration and portal with spsbackup So no individual SQL backups are necessary (at least that's what we thought :)), since all the backups that are being made are extracts of SQL. In the document by Microsoft there are scripts to automate this whole process. The only thing we didn't do is doing a backup transaction log of each database. By not doing this, this log will grow and grow and in the worst case scenario it consumes all of the harddisk space of your database server. So the recommended solution : - STSADM Backup your sites with stsadm - SPSBACKUP Backup your configuration and portal with spsbackup - Transaction log backup Backups the transaction log

1 comment:

infopath signing said...

You got a definitely helpful blog I’ve been right here reading for about an hour. I’m a newbie and your accomplishment is quite a lot an inspiration for me.