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

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 Project Server 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.

Leave a Reply

Your email address will not be published. Required fields are marked *