dcsimg

Backing Up and Restoring the System Database using MS SQL Management Studio

0

Products

Webtrends Analytics 9.x
Webtrends Analytics 8.x

Cause

How to back up or restore a database using Microsoft SQL Management Studio

Resolution

Back Up the System Database
To back up the system database using Microsoft SQL Server Management Studio Express, follow the steps below:

1. Download and install Microsoft SQL Server Management Studio from the Microsoft web site:

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms


2. After Microsoft SQL Server Management Studio Express has been installed, launch the application to connect to the system database. The “Connect to Server” dialog box displays.

  • In the “Server name:” field, enter the name of the Webtrends server on which the system database is installed.
  • In the “Authentication:” field select “Windows Authentication” if logged into the Windows machine using the Webtrends service account or an account with rights to make changes to the system database. Otherwise, select “SQL Server Authentication” from the drop-down menu and enter the credentials for a SQL Server account which has the needed rights. Click “Connect” to connect to the database.

    • 3. Expand “Databases,” right-click on “wt_sched” and select “Tasks” > “Back Up…” from the context menu. The “Back Up Database” dialog box displays.
    • Under the “Source” section, ensure the “wt_sched” is selected for the “Database:” and “Backup type:” is “Full.”
    • Under “Backup set” provide a name, description and expiration date as needed and then select “Add…” under the “Destination” section and designate the file name and path where the backup will be saved. It may be necessary to select the “Overwrite all existing backup sets” option in the Options section if a backup already exists and is to be overwritten.
    4. Select “OK” to complete the backup process.

    5. Repeat the above steps for the “wtMaster” part of the database.


    Restorethe System Database
    To restore the system database using Microsoft SQL Server Management Studio, follow the steps below:

    1.If you haven’t already, download and install Microsoft SQL Server Management Studio from the Microsoft web site:
    https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

    2. After Microsoft SQL Server Management Studio has been installed, launch the application to connect to the system database. The “Connect to Server” dialog box displays.
    • In the “Server type:” field, select “Database Engine” (default).
    • In the “Server name:” field, select “<server name>\WTSYSTEMDB” where <server name> is the name of the Webtrends server where the database is located. WTSYSTEMDB is the name of the database instance in a default installation.
    • In the “Authentication:” field select “Windows Authentication” if logged into the Windows machine using the Webtrends service account or an account with rights to make changes to the system database. Otherwise, select “SQL Server Authentication” from the drop-down menu and enter the credentials for a SQL Server account which has the needed rights. Click “Connect” to connect to the database.
    3. Expand “Databases,” right-click on “wt_sched” and select “Delete” from the context menu.
    • Make sure “Delete backup and restore history information for databases” check-box is checked.
    4. Select “OK” to complete the deletion process.

    5. Repeat the above steps for the “wtMaster” part of the database.

    6. Right click on “Databases” and select “Restore Database…” from the context menu.
    • In the “To database:” field type in “wt_sched”.
    • Select the “From device:” radio button.
    • Click on the ellipse (…) to the right of the”From device:” text field.
    • Clickthe”Add” button.
    • Navigate to and select thebackup file for “wt_sched”.
    • Select “OK” on the “Locate Backup File” form.
    • Select”OK” on the “Specify Backup” form.
    • Check the check-boxin the restore column next to”wt_sched-Full Database Backup”.
    • Select”OK”on the “Restore Database” form.

    7. Repeat step6for the “wtMaster” part of the database.

    More Information

    If you need to backup and/or restore your entire installation, please see: How do I perform a manual system backup on a Webtrends installation which uses MS SQL Server 2008?