We recently published a new article set to our Microsoft Project Server 2010 TechNet Library: "Database Maintenance Plans for Project Server 2010". A Project Server 2010 farm environment includes not only the databases required for Project Server, but also databases required for SharePoint Server 2010. Ensuring that these databases are maintained properly is key to smooth performance in your Project Server 2010 environment. This article set contains information and guidelines for maintaining the databases that host Microsoft Project Server 2010. It describes and provides examples of the database maintenance tasks that we recommend when you are using Project Server 2010. This document provides detailed examples for Microsoft SQL Server 2008 R2. External references for how to perform the same database maintenance tasks with Microsoft SQL Server 2008 are also included.
The goal of this article set is to provide you the information to create a database maintenance plan that best fits your environment. This article set includes the following articles:
- Overview of Project Server 2010 databases
- Creating maintenance plans for Project Server 2010 databases
- Defragmenting indexes for Project Server 2010 databases
- Shrinking databases in Project Server 2010
- Monitoring maintenance plans for Project Server 2010
For more information about maintaining the databases that are required for SharePoint Server 2010, read Database maintenance for SharePoint Server 2010. You should read this as well before you implement any database maintenance tasks or modify your Project Server 2010 or Microsoft SharePoint Server 2010 databases.