How to restore ProjectDox database

Rick,

I spoke with Steve and he stated that there were specific things configured in the Project 1027 and that a restore would be the best option otherwise you lose all of the historical workflows that were created in the Project. Please refer to the steps below for the restoration:

1) Prior to doing the restore you will want to STOP the DefaultWebSite in IIS on the ProjectDox web server as well as STOP all services that start with "ProjectDox" in the name field on both the web server and the ProjectDox application server.
2) Rename the current ProjectDox and WorkflowPersistenceStore databases in Management Studio to ProjectDoxOLD and WorkflowPersistenceStoreOLD.
3) Detach both databases and then rename their corresponding .MDF and .LDF files if you are going to leave them in the same directory that you will be doing your restore of the backups so that the files will not have the same name in the file system.
4) Restore the ProjectDox database and the WorkflowPersistenceStore database back to the same point in time before the deletion occurred on 7/1/2016 at 11:20 am. When restoring the databases you will restore them with their normal names and make sure you set the Pdox-SQL account as the Owner in the Restore Options page.
5) After the restore is done, you can reattach the OLD ones if you want to in case there is any data in them that you will need to retrieve such as any submitted Applications since the time of the deletion. When you restore the OLD ones you will need to browse to the location of each of the .MDF and .LDF files in order for the Reattach to work since it will be looking for the original file names.

Please let me know if you have any questions.

Thanks,
Gregory

Gregory Linkous, MCSE
Director Support | Installations
+1 602 903 3133