4
Permissions problems related to the HPWJA_DB_BACKUP.dat file might occur. When the restore.bat
file runs, OSQL commands are activated by the Network Service user under which the SQL instance
also runs. To ensure that the restore is successful, verify that the HPWJA_DB_BACKUP.dat file is
located in a directory to which Network Service has read access.
Some server backup programs might not be able to read the SQL files on the HP Web Jetadmin
installation host. The SQL files remain in use while the HP Web Jetadmin service runs. The HP Web
Jetadmin service must be stopped to allow the backup to execute correctly.
When HTTPS is enabled in HP Web Jetadmin, the customer provides a server-specific SSL certificate.
This server-specific SSL certificate is installed in the Local Computer Certificate Store and can be used
only on the server for which it was generated. If the settings are restored to any other server, including
an OS that is reinstalled on the same physical hardware, the HTTPS configuration is lost. An
authorized user must re-enable the HTTPS configuration from the HP Web Jetadmin console.
If the HP Web Jetadmin installation is configured to connect to Microsoft SQL Server (non-Express
edition) that resides on the same server host, the SQL Server instance and database must exist and be
correctly configured before the restore script runs. The restore script must be modified to restore data
to the SQL Server instance. Providing the details for this configuration is beyond the scope of this
document. For more information, see the Using Microsoft SQL Server with HP Web Jetadmin white
paper. This white paper is available from the HP Web Jetadmin support page
.
HP Web Jetadmin also offers a licensed feature for off-host connections to SQL Server. These
configurations are not considered in the backup and restore script examples. Special backup and
restore considerations are required when working with off-host connections to SQL Server.
Run the backup script
To run the backup script, open a command window, change to the directory where the batch file is
located, and type backup.
The following steps occur during the backup:
1. Variables are set that define the directories where the files and SQL Server Express database are
located.
2. The script checks for the existence of the files or directories. If files or directories from a previous
backup already exist, errors are posted and the script terminates. If this occurs, move the previous
database backup files and Settings directory to a separate location outside of the C:\Program
Files\HP Inc\Web Jetadmin 10\WJABackupRestore directory.
3. A disclaimer appears stating that the backup file is for illustrative purposes only and instructing
the user to press any key to begin the process.
4. The HP Web Jetadmin service is stopped before the files are copied or the database is backed
up. The backup script runs the following commands to stop the HP Web Jetadmin service:
%SERVICE% -stop
%SERVICE% -wait-on-stop
where
SERVICE=C:\Program Files\HP Inc\Web Jetadmin 10\bin\HPWJAServiceCtrl.exe
If the service cannot be stopped for any reason, errors are posted.
5. After the service is stopped, the backup process begins by running the following .sql command to
back up the database:
%OSQL% -S localhost\HPWJA -E -i osql_backup.sql > osql_backup.log
(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