The Archive Database in Project Server 2007

The archive database in project server 2007 isn't really a database that facilitates a functionality of archiving projects. The archive database is the database used to backup projects to and restore projects from.

The projects will still exists in the Draft and Published Databases.Looks like archiving of projects will still need to be done in a way as described in this link.

Another interesting information on the backup of databases is the backup is an all or nothing process but the restoring of a project can be done on an individual basis.

Project Server 2007 Pre-migration Checklist

I've recently been involved in our in house project server 2003 - 2007 migration. Below is a useful list in helping build a checklist and identifying possible issues with migration.

• Checking for check-out projects
• Checking for Projects that have been externally edited
• Checking for projects with pending status updates
• Checking for duplicate Enterprise Resources
• Checking for duplicate Enterprise Resource used in projects
• Project Version should be at least ‘Project Server 2003 SP2A’
• Enterprise Global should not be externally edited
• Checking if the Enterprise Global is checked out
• Checking of the Enterprise Global is locked
• Checking if the default language on the Web tables database and Project tables database and Project tables database should match
• Checking if Resources have comma in their names
• Checking if required enterprise resource custom fields do not have values
• Checking if a resource custom field has a value which is not in the lookup table definition
• Checking if Enterprise resources are externally edited
• Checking if there are Enterprise Resource Duration custom fields with value lists
• Checking if Enterprise Resource Duration custom fields contain valid values
• Checking if Enterprise Custom Field names do not contain leading or trailing spaces
• Checking if the Migration Administrator Account exists in Project Server 2003

More information at the link: http://technet2.microsoft.com/Office/en-us/library/9d828b0a-8361-4580-aa67-fe931281803c1033.mspx?mfr=true