• Article

Project Server VME: Create a backup of the existing Project Server 2003 database

 

Applies to: Project Server 2010

Topic Last Modified: 2013-12-18

This article describes how to create backups of your Microsoft Office Project Server 2003 databases in your Project Server 2003 environment. You can then move them to the Project Server virtual migration environment (VME) to migrate your data to Microsoft Office Project Server 2007.

  • If the Project Server 2003 data is contained in a single database, create a backup of your Project Server database.

  • If your Project Server 2003 data is split into two databases, create a backup copy of both your Project Server database and your Project Web database.

  • Optionally, if you are migrating your project workspace data, you have to make a backup of the Windows SharePoint Services 2.0 content database that contains your project workspace data.

You may want to make the Project Server 2003 database backup files accessible to the virtual migration environment virtual machine by copying them to an external hard drive. This allows you to attach the external hard drive to the virtual machine host to make them accessible to the VME. After you have migrated your Project Server 2003 data to Office Project Server 2007 on the VME, you can then copy the migrated data to the external hard drive in order to upgrade in Project Server 2010.

Important

Project Server 2003 Service Pack 3 is a requirement for migrating your data to Office Project Server 2007. Prior to creating database backups, verify that Project Server 2003 Service Pack 3 is installed in your Project Server 2003 environment. Additionally, if you have project workspace data that you plan to migrate, you should also verify that Windows SharePoint Services 2.0 is updated to Service Pack 3.

This article describes one of several tasks that is required to configure your Hyper-V environment for the Project Server virtual migration environment. For more information about other tasks required to configure your Hyper-V, see Configure the Hyper-V environment for the Project Server VME. For more information about the VME, see Overview of the VME for Project Server 2010.

Create a backup of existing Project Server 2003 databases

Use either of the following procedures to create a backup of the Project Server 2003 databases that you need for the VME.

  • To back up a database in SQL Server 2000

  • To back up a database in SQL Server 2005

To back up a database in SQL Server 2000

  1. On the database server, click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager.

  2. In SQL Server Enterprise Manager, expand Microsoft SQL Servers.

  3. Expand SQL Server Group.

  4. Expand (local) (Windows NT).

  5. Expand Databases.

  6. Right-click the database that you want to back up, point to All Tasks, and then click Backup Database.

  7. In the SQL Server Backup dialog box, in the Name box, specify a name for the backup, and then, in the Backup area, select Database - complete.

  8. In the Destination area, either select an existing destination or do the following:

    1. Click Add.

    2. In the Select Backup Destination box, select File Name, and then, next to the File Name box, click Browse.

    3. In the Backup Device Location - (local) dialog box, in the File name box, type a file name, and then click OK.

    4. Click OK again to close the Select Backup Destination dialog box.

  9. Click OK to start the backup process.

  10. Click OK to acknowledge that the backup process is complete.

To back up a database in SQL Server 2005

  1. On the database server, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

  2. In the Connect to Server box, specify the connection information, and then click Connect.

  3. After you connect to the appropriate instance of the SQL Server 2005 Database Engine, in Object Explorer, expand the server tree by expanding the server name.

  4. Expand Databases, right-click the database that you want to back up, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.

  5. In the Source area, in the Database box, verify the database name.

  6. In the Backup type box, select Full.

  7. In the Backup component section, select Database.

  8. In the Backup set area, in the Name box, either accept the default backup set name that is suggested or type a different name for the backup set.

  9. In the Destination area, specify the type of backup destination by selecting Disk, and then specify a destination. To create a different destination, click Add.

  10. Click OK to start the backup process.