Backup and Restore Process for SmartStruxure WebReports

Backup and Restore Process for StruxureWare Web Reports

SmartStruxure

WebReports

Reports Server

Need detailed backup process

Backing Up the WebReports Database 

1. On the Windows toolbar, select Start, and then click SQL Server Management Studio.
2. Click Connect.
    
   Note: When using a remote Computer to connect to the Report Server SQL database, the Windows Accounts must exists on both machines and have administrative rights for the SQL database otherwise a successful backup will not occur.  In this instance it is recommended to use the SysAdmin 'sa' login / password details when connecting in remotely.
    
3. Expand the Databases folder.
4. Right-click StruxureWareReportsDB, point to Tasks, then click Back Up.
   
5. Under Destination, click Add.
   
6. Click OK.
7. In the Destination on disk box, select the backup destination.
   
8. Click OK.
9. Click OK.

Restoring the WebReports Database

1. You restore the WebReports database to recover reports data from backup.
2. On the Windows toolbar, select Start, and then click SQL Server Management Studio.
   
3. Click Connect.
4. Expand the Databases folder.
   
5. Right-click StruxureWareReportsDB and select Tasks, then select Restore, then select Database.
   
6. In the Restore Database dialog box, select the database set(s) that you want to restore.
7. Click OK.
   
8. Click OK.