Restoring Webtrends Visitor Data Mart Data

Explains how to restore Visitor Data Mart data for a profile, not for your entire Visitor Data Mart installation. It includes instructions for restoring Visitor Intelligence cube data. For information about disaster recovery, you should contact Webtrends Support.

  1. In the left pane, click Administration > Web Analysis > Reports & Profiles .
  2. Edit your Visitor Data Mart profile and select Analysis > Event Analysis .
  3. Click Analysis Paused. Pausing analysis allows Visitor Data Mart to continue collecting data while event data loading and other analysis processing is suspended.
  4. Using the third-party SQL tools of your choice, restore the Event Database, Module Database, and Extended Attributes Database for the profile.
  5. To restore from the .xmla file created when you backed up the Analysis Services Database, open a query in Microsoft SQL Server Management Studio or execute wtascmd.exe.
  6. Perform a complete cube reprocess:
    1. Open a command prompt and navigate to the wtCube directory.
    2. Execute this command:

      wtcube profileguid -processfull

      where profileguid is the ID for the profile you are restoring. You can find this ID by editing the profile in Webtrends Administration and clicking Summary.

  7. In the left pane, click Administration > Web Analysis > Reports & Profiles .
  8. Edit your Visitor Data Mart profile and select Analysis > Event Analysis .

Was this topic helpful? Send feedback.