Microsoft KB Archive/323330

Knowledge Base

How to back up, schedule, and restore a Microsoft Project Server database

Article ID: 323330

Article Last Modified on 2/1/2007

---

APPLIES TO

• Microsoft Office Project Server 2003
• Microsoft Project Server 2002

---

This article was previously published under Q323330

SUMMARY

This article explains how you can create, schedule, and restore a backup of your Microsoft Project Server database.

Back Up the Database

After you have completed the Microsoft Project Server installation, Microsoft recommends that you create a backup of the new database. To create a backup by using Microsoft SQL Server Enterprise Manager, follow these steps:

1. Click Start, point to Programs point to Microsoft SQL Server, and then click Enterprise Manager.
2. Expand Microsoft SQL Servers, expand SQL Server Group, expand your Microsoft Project Server database server, and then expand Databases.
3. Right-click the Microsoft Project Server database, point to All Tasks, and then click Backup Database.
4. Click the General tab; under the Destination heading, click Add next to the Backup to box.
5. In the Select Backup Destination box, click File name, and then click the ellipsis button (...) to browse the file system.
6. In the Backup Device Location dialog box, navigate to the file system location for your backup.
7. In the File name box, type a name for the backup, and then click OK two times.
8. Click the Options tab, click to select the Verify backup upon completion check box, and then click OK to start the backup.
9. Click OK in the backup confirmation dialog box.

Scheduling Backups

After you have completed the Microsoft Project Server backup, Microsoft recommends that you schedule regular backups of the database.

Start the Agent

To run scheduled backups, start the SQLSERVERAGENT service, and then set it to an Automatic startup type. To start the SQLSERVERAGENT service, follow these steps:

1. Click Start, point to Programs, point to Administrative Tools, and then click Services.
2. In the right pane, locate and right-click SQLSERVERAGENT, and then click Properties.
3. In the SQLSERVERAGENT Properties dialog box, click Automatic in the Startup type list, and then click Start.
4. Click OK.
5. Close the Services tool.

Schedule the Backup

To schedule backups, follow these steps:

1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
2. Expand Microsoft SQL Servers, expand SQL Server Group, expand your Microsoft Project Server database server, and then expand Databases.
3. Right-click the database used by Microsoft Project Server, point to All Tasks, and then click Backup Database.
4. Click the General tab; under the Destination heading, click Add next to the Backup to box.
5. In the Select Backup Destination box, click File name, and then click the ellipsis button (...) to browse the file system.
6. In the Backup Device Location dialog box, navigate to the file system location for your backup.
7. In the File name box, type a name for the backup, and then click OK two times.
8. In the SQL Server Backup dialog box, click to select the Schedule check box.
9. Click the ellipsis button (...) to edit the backup schedule.
10. In the Edit Schedule dialog box, type a name for the schedule, modify the backup frequency, and then click OK.
11. Click the Options tab, click to select the Verify backup upon completion box, and then click OK to start the backup.

Restoring the Database

To restore the Project Server database, you can use the restore feature of Microsoft SQL Server. After you restore the database, you must delete and then re-create the MSProjectServerUser and MSProjectUser accounts to make sure that the correct passwords are configured. To do this, follow these steps:

1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
2. Expand Microsoft SQL Servers, expand SQL Server Group, expand your Microsoft Project Server database server, and then expand Databases.
3. Right-click the Microsoft Project Server database, point to All Tasks, and then click Restore Database.
4. From the list of backups, click the backup to restore, and then click OK to start the restore.
5. Click OK to confirm that the restore completed successfully.

To delete and re-create the database users, follow these steps:

1. Expand your restored Project Server database.
2. Click Users, and then click the MSProjectServerUser user.
3. Press DELETE, and then click Yes to confirm the deletion.
4. Click MSProjectUser, and then press DELETE.
5. Click Yes to confirm the deletion.
6. Right-click Users, and then click New Database User.
7. Under Login name, click MSProjectServerUser, and then under Database role membership select MSProjectServerRole.
8. Click OK.
9. Right-click Users, and then click New Database User.
10. Under Login name, click MSProjectUser, and then under Database role membership select MSProjectRole.
11. Click OK.
12. Log on to Microsoft Project Web Access to verify the connection.

MORE INFORMATION

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

241397 How To Back Up a Microsoft Data Engine Database with Transact-SQL

For additional information about database restoration, see the Disaster Recovery Guide at the following Micrososft Web site: http://www.microsoft.com/technet/prodtechnol/office/proj2003/reskit/distrcv.mspx

Keywords: kbhowto kbinfo KB323330

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.