Thinking about upgrading to SharePoint 2010? Might want to know a thing or two about making SharePoint 2007 backups first.

(c) Sean Bordner

(c) Sean Bordner

Microsoft provides a great deal of information which details many different SharePoint backup strategies. Here’s a “brief” outline of the SharePoint 2007 components which should be backed up frequently.  The specifics of how and when backups are performed are largely determined by your organizations Backup & Restore Policies.
1.      Database Server:  Backup the SharePoint Config DB and all SharePoint Content DB’s.  Keep track of the size of the content databases. If they become too large, think of splitting them up.  This way the backups will complete before users are on the system.
2.      Web Front End Servers (SharePoint Servers):  Backup the entire 12 hive (c:\program files\common files\microsoft shared\web server extensions\12). This ensure you have backups of any SharePoint specific components which have been added to your farm (custom web parts, etc…).
3.      Web Front End Servers (SharePoint Servers):  Backup the INETPUB directory (all of it).
SharePoint Backups should be scheduled to run during times of minimal usage (typically at night). 
Considerations should be made to the time it takes to backup each of the different components.  There are four types of backups in a SharePoint environment as follows:
1.      Web Front End Server
a.      Inetpub folder
b.      IIS metabase
c.      Custom components:
                                                    i.     Assembles
                                                   ii.     Templates
d.      Configuration files
2.      SQL Server – differential (daily)
3.      SQL Server – full (weekly)
4.      SharePoint log files (daily)
5.      Search Indexes (frequency based on size, it’s not hard to rebuild from scratch if it’s not super big)
How to make SharePoint 2007 Backups
Microsoft Office SharePoint Server 2007 provides a backup & restore utility.  It can be accessed from Central Administration site or by using the Stsadm command-line. This utility provides the following capibilities:
• Run backup or restore jobs directly from Central Administration.
• Manage backup and restore jobs remotely.
• Schedule backup jobs using a batch script.
This utility also provides the following restore capabilities for your Office SharePoint Server 2007 solutions:
• Restores all SharePoint web applications, content databases, and SSP databases.
• Automatically attaches databases when restoring.
• Restores the search index (or indexes).

About Sean Bordner

CEO, Solution Architect, Co-Author of SharePoint for Nonprofits, Contributing Author MCT, MCTS, MCSD, MCP, MCAD
This entry was posted in Backups, SharePoint. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s