Installation guide

3. Ensure that Migration Complete Successful appears at the end of the log file.
If this message does not appear, review the rest of the log file to see where the upgrade failed.
Solve the problem, then rerun the upgrade script.
Backing up the SQL Server 2008 R2 database
(Topic number: 147840)
7.
After upgrading SQL Server, to guard against information loss, manually back up the database again.
Note:
Before backing up the database, confirm that you have stopped the IMPAX services, emptied
and halted all queues, and shut the database down.
For more details, see Preparing to upgrade (refer to page 11).
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
AS300 Upgrade Guide—IMPAX 5.2 or 5.3 to IMPAX 6.5.3 30
Agfa Company Confidential—Subject to Non-Disclosure Obligation