Step 1:- Once you launch Stellar Phoenix Project Server Recovery, the main interface appears as shown above. You need to run repair on a copy of the Project Server database. On the ‘File’ menu, select ‘Open Project Server Database’.
Step 2:- The ‘Select View’ dialog box appears on your screen. Select ‘Document Recovery’ to extract documents from the Project Server database or choose ‘Complete Repair’ to repair the damaged database.
Step 3:- If you choose ‘Complete Repair’, the above dialog box is displayed. Browse to the desired location and provide path of the Content database, Draft database, Published database, Archive database, and Reporting database associated with the Project Server database you need to repair. Click ‘OK’.
Step 4:- After selecting the databases, click ‘Start Repair’ icon on the toolbar. The above message box appears. Click ‘OK’ to proceed.
Step 5:- Specify the location for saving the repaired Content database and type in your SQL Server Instance name in the ‘Enter your server Name (Server Name\Instance Name)’ box. Click ‘OK’.
Step 6:- When the repair process is finished, the ‘Attach Content Database’ dialog box is displayed. Specify the URL of the web application to which you need to attach the content database, the name of the Shared Services Provider for the web application and the administrator domain account for the instance. Click ‘OK’.
Step 7:- The software will create a new PWA instance, extract documents from the corrupt PWA instance, transfer the documents to the newly created instance, and display you the above message box. You need to manually edit the URL of old project workspace.