User guide

4. 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.
5. To start the backup, click OK.
6. Exit the SQL Server Enterprise Manager.
Restoring the upgraded database on a new Database Server4.
CAUTION!
Perform this task only when replacing an existing server with a new server. Be very careful
not to delete any live database files. Perform this procedure only on a new server that has
not had any clinical use, even as a training server. Do not perform this procedure on any
production, training, or traveling servers.
When replacing the existing server with a new server, you first install the IMPAX 6.4 server software
on the new server. You then upgrade the database on the old server, and back up the upgraded database.
Finally, you restore a backup of the upgraded database onto the new server, as described in this topic.
Note:
Shut down all applications that usually connect to the SQL Server database. Under Services,
stop the SQL Server agent. Also, shut down the SQL Server Query Analyzer when not using
it as part of the restore process.
To restore the upgraded database on the new Database Server
1. If you are restoring from tape, insert the backup tape into the tape drive.
2. In the Explorer window of the SQL Server Management Studio, expand server > Databases >
System Databases
where server is the name of the SQL Server that IMPAX is running under.
3. Right-click the mvf database to restore and select Tasks > Restore > Database.
4. In the Restore database dialog, beside Restore, select From device.
5. Click Select Devices. Click OK.
6. Under Backup set to restore backup set, select Database - complete.
7. Switch to the Options tab.
8. Select Overwrite the existing database.
9. Select Leave database ready to use by rolling back uncommitted transactions. Additional
transaction logs cannot be restored. Click OK.
The database is restored. After the restore is complete, a confirmation message appears stating
whether the restore was successful.
10. Restore the mvf user permissions:
a. Open SQL Server Management Studio.
AS300 Upgrade Guide—IMPAX 6.2 or later to IMPAX 6.4 33
AGFA COMPANY CONFIDENTIAL