Following Article will help you to Backup,Schedule and restore the databse of Project server. 

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.

For More Information, Visit:
http://support.microsoft.com/default.aspx?scid=kb;en-us;323330

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: