Database maintenance plans for Project Server 2007
Updated: September 19, 2008
This article provides information and guidelines for maintaining the databases that host Microsoft Office Project Server 2007 and Microsoft SharePoint Products and Technologies data and configurations. It describes and provides examples of the database maintenance tasks that we recommend when using Office Project Server 2007.
This document provides detailed examples for SQL Server 2005. External references for how to perform the same database maintenance tasks with SQL Server 2000 are also included. Similar functionality is also available with SQL Server 2008.
Before you implement any database maintenance tasks or modify your Office Project Server 2007 or SharePoint Products and Technologies databases, read the following MSDN support articles:
Support for changes to the databases that are used by Office server products and by Windows SharePoint Services (http://go.microsoft.com/fwlink/?LinkID=110812&clcid=0x409)
Information about the Maintenance Plan Wizard in SQL Server 2005 and about tasks that administrators can perform against SharePoint databases (http://go.microsoft.com/fwlink/?LinkID=110813&clcid=0x409)
A well-defined database maintenance plan and process are essential for the smooth operation of Office Project Server 2007 and SharePoint Products and Technologies databases. This document describes the key concepts, database maintenance tasks supported for Office Project Server 2007 databases, and best practices.
Broadly, the recommended database maintenance tasks for Office Project Server 2007 databases include:
Checking database integrity
Defragmenting indexes by either reorganizing them or rebuilding them
Setting the fill factor for a server
Monitoring database size to determine whether to grow or shrink databases
If your organization wants the simplest possible database maintenance plan, we recommend that you use a default SQL Server maintenance plan. For more information, see Maintenance Plan Wizard (http://go.microsoft.com/fwlink/?LinkId=128441&clcid=0x409) in the SQL Server Books Online.
To help you create a database maintenance plan for your Office Project Server 2007 deployment, consult the following articles in this section: