Microsoft extends the capabilities of Microsoft Project with Project Server and Web Access. Microsoft Project Server stores project information in a central database, protected from unauthorized access and corruption. A Project Administrator can control security defining users and access rights. A big question is there how Microsoft Project Server stores data and what are the databases used by Microsoft Project Server ?

Microsoft Project Server uses four databases to store data on SQL server 205.

1. Archive: As the name suggests Archive database stores backup and other older data in Archive Database.
2. Draft: Draft Database data about the unpublished projects from Project Professional or any other application. Project Web Access does not show project data in the Draft database. Draft database also stores tables that are used for project queue.
3. Published: The Published database contains all of the published projects as well as enterprise resources, the enterprise global template, and other project templates. Published projects are visible in Project Web Access. The Published database also contains tables that are specific to Project Web Access (timesheets, models, views, and so on), and global data tables (outline codes, security, and metadata).
4. Reporting: Contains the same data as the Published database, but optimized for generating reports and online analytical processing (OLAP) cubes. Data in the Reporting database is updated nearly in real-time, is comprehensive, and is optimized for read-only report generation.

This diagram show how these databases are fit into the Project Server 2007 Architecture

Credit: MSDN

You may also like to read

• Amitabh Bachchan Started His Own Blog (314)
• Contact Us (39)
• Kabhi Kabhi Aditi Lyrics…….For your dear ones… (36)
• Gmail and AdSense Using Invalid Security Certificate (24)
• 8 Things that Google Ignores (22)