Installation guide

Note:
Before backing up the database, confirm that you have stopped the IMPAX services, emptied
and halted all queues, and shut the database down.
More details are available in Preparing to upgrade (refer to page 15).
Ensure that you are logged in using the AgfaService account; you cannot log into SQL Server
Management Studio or back up the database from the command line using the Administrator
account.
To back up the SQL database using SQL Server Management Studio
1.
Select Start > All Programs > Microsoft SQL Server.
2.
Right-click SQL Server Management Studio and select Run as.
3.
Select The following user. Type AgfaService as the user name, and the AgfaService password.
If you do not know the AgfaService password, you can run the passkey utility to find it: passkey
-M QUERY -u AgfaService.
4.
In the Object Explorer window, expand server > Databases > database_name
where server is the name of the SQL Server that IMPAX is running under and database_name
is the name of the database to be backed up.
5.
Right-click database_name and select Tasks > Backup.
6. Configure the General and Options tabs according to your preferences for items such as the
type of backup, the destination, and whether to overwrite or append to the media.
7.
To start the backup, click OK.
8. Exit the SQL Server Management Studio.
To back up the SQL database from the command line
1. At a command prompt, type
sqlcmd -U sa -P sa_password -dmaster
2. To back up the database, type
backup database database_name to device_name
where database_name is the name of the database to back up and device_name is the logical or
physical name of the tape or disk device.
AS300 Upgrade and DAA Consolidation Guide—IMPAX 6.2 or 6.3 to IMPAX 6.5.3 33
Agfa Company Confidential—Subject to Non-Disclosure Obligation