Steps to Restore Contributor application to a different database and application name

To accomplish this, first back up the Contributor application then restore the database using SQL Enterprise Manager. Restore it to a new database name, then link to new application within the Contributor Admin console.

Follow these steps to restore a Contributor Application to a new database name:
1. From the Contributor Admin Console, Expand the application you want to backup, expand Development, expand Datastore options, then select Datastore Maintenance.
2. Make a note of the location that you're backing up your files to, and then click Backup.
3. Launch SQL Enterprise Manager and browse to Databases.
4. Right-click Database and select 'All tasks', then 'Restore database'.
5. In the Restore as Database field, type the new name for the database (make certain there are no uppercase characters in the name).
6. In the Restore section click From Device, click Select Devices, click Add.
7. In the File name section browse to the location where you saved your backup database.
8. Select the .dat file that was saved in step 2, then click OK, click OK again, then click OK again.
9. Go to the Options tab and in the Move to physical filename field, type the path where you want to restore the new database to. Do the same for both the log file and the dat file.
10. Go to the General tab, select View Contents and make sure you check off the latest backup set date. (The date should correspond to the date when you performed your backup in step 2.)
11. Click OK, and click OK again. The SQL Restore is complete.
12. Launch Contributor Admin Console, right-click your Datastore server and select Link to Existing Application.
13. You should see the Application name of the new database you just restored, check that off and select Add.