Installation guide

isqlw
7.
When prompted, type sa as the user name and type the sa password.
8. To back up the database, type
backup database mvf to disk = 'file_path:\mssql\backup\oldserver.dat' with stats
where file_path is the location of the database files. For example
backup database mvf to disk = 'C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\oldserver.dat' with stats, init
9. At the next command prompt, type
backup log mvf to disk = 'file_path:\mssql\backup\oldserver.dat' with stats
The oldserver.dat produced contains two files: the database backup and the transaction log
backup.
10. From the C:\mvf\bin directory, type
installall.bat
This restores the services removed earlier.
11. To start up IMPAX, type
startall.bat
Restoring the database on the new SQL Database
Server
(Topic number: 7627)
2.
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.5.3 server software
on the new server. You then restore the backed-up database on the new server, as described in this
topic, before upgrading the schema.
To restore the database on the new SQL Database Server
1. Ensure that the new server database partition is as large as the original physical data files.
Independent of the size of the backup, the restore causes the new data files to be as large as the
original ones.
2. If not already done, shut down related services.
AS300 Upgrade and DAA Consolidation Guide—IMPAX 6.2 or 6.3 to IMPAX 6.5.3 25
Agfa Company Confidential—Subject to Non-Disclosure Obligation