7
A message appears in the command window that specifies the number of files that were copied
and states that an osql_restore.log file is available for viewing. There should be no errors present.
7. The following commands start the HP Web Jetadmin service:
%SERVICE% -start
%SERVICE% -wait
HP Web Jetadmin can now be launched to determine if all of the printers are present and all of the
settings are restored.
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 =
'C:\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
(54 páginas)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentários a estes Manuais