Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Backup and Restore Process for SmartStruxure WebReports

Issue

Backup and Restore Process for StruxureWare Web Reports

Environment

SmartStruxure

WebReports

Reports Server

Cause

Need detailed backup process

Resolution

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.
Tags (1)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2018-09-11 12:41 AM
Updated by: