Maintaining Project Server 2003 SQL Server Databases

Depending on your organization, you may have a database administrator (DBA) who is already comfortable with maintaining SQL databases. This section outlines recommendations for maintaining the Project Server 2003 databases in SQL Server 2000 and is meant to be more of an overview and a checklist than a detailed how-to. Typical DBA tasks still apply.

Database Lists and Functions

A typical Project Server 2003 implementation includes three main databases. Table 25.2 lists these databases and their functions.

Table 25.2. Project Server Databases
DatabaseDescription
Project Server DBContains the views, resource, outline codes, and project tables, as well as tables linking projects and tasks to WSS ...

Get Microsoft® Office Project Server 2003 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.