HP Web Jetadmin Software - Backup and Cloning of an HP Web Jetadmin Installation

BACK UP AN HP WEB JETADMIN INSTALLATION THAT IS

CONFIGURED FOR A REMOTE DATABASE

It might be necessary to run scheduled backups of an HP Web Jetadmin installation that points to a

remote SQL Server database instead of the local SQL Server Express database. HP Web Jetadmin

provides a script to back up the default SQL Server Express database instance that is installed with the

base product. The script also backs up the HP Web Jetadmin configuration settings. If the backup and

restore scripts in the HP Web Jetadmin installation directory (WJABackupRestore) were used

previously to back up the local HP Web Jetadmin installation, consider the following options to ensure

that the remote database is backed up:

 Option 1: Backing up and restoring the remote database is not done by using HP Web Jetadmin.

There might already be other processes in place for backing up the remote SQL Server database

and the HP Web Jetadmin Settings directory. In this case, the HP Web Jetadmin backup script is

not required.

 Option 2: Continue to use the HP Web Jetadmin backup script, but remove or comment out the

lines in the script that back up the database. The script continues to back up the HP Web

Jetadmin Settings directory. There might already be other processes in place for backing up the

remote SQL Server database. In this case, backing up the remote database is not performed by

HP Web Jetadmin.

 Option 3: Modify the HP Web Jetadmin backup script to back up the remote database and the

HP Web Jetadmin Settings directory. The lines in the script that back up the default SQL Server

Express database instance can be replaced with custom commands that back up the remote

database. For example, the HP Web Jetadmin backup.bat file runs the following SQL script on

the same machine to back up the database:

%OSQL% -S localhost\HPWJA -E -i osql_backup.sql > osql_backup.log

To run the script on the remote SQL server, change this line to the following:

%OSQL% -H wksta_server -S SQL_server\Instance -U user -P password -i osql_backup.sql >

osql_backup.log

The SQL script backs up a database named HPWJA to DRIVE:\.

BACKUP DATABASE HPWJA TO DISK =

'DRIVE:\HPWJA_DB_BACKUP\HPWJA_DB_BACKUP.dat'

To back up any database name to a shared UNC path, change this script to the following:

BACKUP DATABASE database_name TO DISK = '\\WJA

_server\shared_directory\HPWJA_DB_BACKUP\HPWJA_DB_BACKUP.dat'

The backup.bat file creates a temporary directory where the .dat file is written, and then removes the

temporary directory after the .dat file is copied to the Program Files location. Because the backup.bat

file looks for the .dat file in this temporary directory and it is impossible to share out this temporary

directory because it does not always exist, an additional permanent directory can be created and

shared. The SQL script can be modified by adding an additional line to the backup.bat file to copy

the .dat file from this shared directory to the HP Web Jetadmin temporary directory. Now the

backup.bat script is never disrupted and can continue from that point.