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

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

« Go Back
Products
Webtrends Analytics 9.2x
Webtrends Analytics 8.7x
Webtrends Analytics 8.5x
Introduction
How to back up or restore a database using Microsoft SQL Management Studio
Next Steps
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 2008 Management Studio Express from the Microsoft web site: http://www.microsoft.com/en-us/download/details.aspx?id=7593

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.


Restore the 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 2008 Management Studio Express from the Microsoft web site:
http://www.microsoft.com/en-us/download/details.aspx?id=7593


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.
  • Click the "Add" button.
  • Navigate to and select the backup file for "wt_sched".
  • Select "OK" on the "Locate Backup File" form.
  • Select "OK" on the "Specify Backup" form.
  • Check the check-boin the restore column next to "wt_sched-Full Database Backup".
  • Select "OK" on the "Restore Database" form.

7. Repeat step 6 for 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?
 
Was this article helpful?

Please tell us how we can make this article more useful.

Characters Remaining: 255