How do I perform a manual system backup on a Webtrends installation which uses MS SQL Server 2005?


Webtrends Analytics 8.5
Webtrends Analytics 8.7


Before making non-trivial changes to a Webtrends installation it is recommended a backup of the system’s core components be made to allow recovery of the installation should issues arise. At its core, a Webtrends installation consists of the system database (in two parts, wt_sched and wtMaster) and the storage repository. If the system database has been backed up and the storage repository has been copied to a safe location, even in the event of a complete system failure the installation and its data can be restored to a working state.


Back Up the Storage Repository
1. The Webtrends Storage repository is located in the following default path:


2. Stop all Webtrends services except for the system database.

3. Once all services have been stopped, copy the storage folder to the backup location. The contents of the storage folder may occupy significant drive space. Ensure the backup location contains sufficient drive space and enough time has been allotted for it to copy.

Back Up the System Database
The system database can be backed up using Microsoft SQL Server Management Studio or from the command line.

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

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


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.

To back up the system database from the command line, perform the steps below:
1. Open a command prompt window and type the following command, then hit Enter:

sqlcmd -S<server name>

…where <server name> is the name of the server on which the system database is installed.

Successful execution of the command displays a numbered SQL prompt similar to the following:


Commands can be entered on a single line or line by line, after which they increment until executed. Commands are executed with the “GO” command.

2. Type the following command, then hit Enter:


…where is the path on the system to where the backup file will be saved, and is the name of the part of the database being saved.


BACKUP DATABASE wt_sched TO DISK=’C:\backups\wt_sched.bak’ WITH FORMAT; BACKUP DATABASE wtmaster TO DISK=’C:\backups\wtmaster.bak’ WITH FORMAT;

3. Type the following command, then hit Enter:


The backup command executes and a backup of both parts of the database are saved under the name and path specified.