HP Web Jetadmin Software Instrukcja Użytkownika Pobierz pdf (Strona 17)

Method 1

One technique to migrate the existing HP Web Jetadmin database from the old instance to the new

instance involves manually copying the database files from the old location to the new location.

Database files are located in the following directory:

C:\Program Files\Microsoft SQL Server\MSSQL.x\data (where x=1, 2, 3, and so on)

Directories are named MSSQL.1, MSSQL.2, and so on, depending upon how many instances are

installed under SQL Server. Locate the directory that contains the HP Web Jetadmin database files

named HPJWJA.mdf and HPJWJA_log.ldf. These files must be copied to the same location under the

MSSQL.1, MSSQL.2, and other directories for the new instance.

Stop the HP Web Jetadmin service before copying the files. Back up the current blank database files

as a precaution. It is very likely that the previous database files must be detached from the old

instance before copying them to the new instance. Stopping the SQL Server service should allow the

files to be copied.

SQL Server Management Studio can also be used to back up and restore or detach and attach the

databases. Stop the HP Web Jetadmin service before copying the files or manipulating the databases

in SQL Server Management Studio.

After the files are copied or the database is restored by using SQL Server Management Studio, start

the HP Web Jetadmin service and use a client to verify success. Verify that the All Devices list contains

the same number of devices that HP Web Jetadmin contained before the migration.

Method 2

If the HP Web Jetadmin database was backed up by using the backup.bat script prior to pointing to

the new instance and database, SQL Server Management Studio can be used to restore the database

from the HPWJA_DB_BACKUP.dat file that was created using the HP Web Jetadmin backup.bat

script.

To restore the database using this method, stop the HP Web Jetadmin service under Administrative

Tools, Services. Start SQL Server Management Studio, and connect to the new HPWJA_FULL SQL

instance (or the name that was chosen for the new instance). Locate the database catalog named

HPWJA listed in the navigation tree under Databases. Using the right-click menu, run Tasks, Restore,

Database. This launches a dialog for selecting From Device as the source of the restore data. Use the

dialog launched through the … button to navigate to the HPWJA_DB_BACKUP.dat file that the

backup.bat script created. After the file is selected in the Restore Database dialog, select the Restore

box in the listing of …backup sets to restore. At this point a backup.dat file that is used to restore data

from the original database instance to the new database is identified.

The HPWJA_DB_BACKUP.dat file also contains the paths to key database files on the old SQL

database instance. These file paths must be changed. The path might be …\MSSQL.1\Data\... for

the initial HP Web Jetadmin SQL database instance. The path might be …\MSSQL.2\Data\... for the

new SQL database created in this procedure. Set the path to the latter in the SQL Restore Database

dialog. To perform this operation, change the settings page from General to Options, select the

Overwrite the existing database checkbox, and then set the paths listed under Restore the database

file as. Remember, these paths should be changed from the old SQL instance file paths to the new

paths. In this example, the following new paths are used:

C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\HPWJA.mdf

C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\HPWJA_log.ldf

1 2 ... 12 13 14 15 16 17 18 19 20 21 22 ... 29 30

Komentarze do niniejszej Instrukcji

Brak uwag

HP Web Jetadmin Software Instrukcja Użytkownika Strona 17

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie HP Web Jetadmin Software