Installation guide

6.
To start the backup, click OK.
7. Exit the SQL Server Enterprise Manager.
Saving the map_event_audit tables from an
AS300 SQL Server database
(Topic number: 106543)
7.
When upgrading an IMPAX AS300 system running SQL Server, follow this procedure.
To save the map_event_audit tables from an AS300 SQL Server database
1.
Start the SQL Server Query Analyzer and log in as the sa user.
2.
From the drop-down database list in the top toolbar, select mvf.
3. In Query Analyzer, type
sp_spaceused MAP_EVENT_AUDIT
4.
Click Execute a query.
5. Note the reserved size value returned by the previous command.
This value is the space required to export the data. If the amount of available disk space is not
sufficient for the exported data, free up some disk space.
6. Open a command prompt.
7. To save the map_event_audit tables, type
bcp mvf..map_event_audit out location_you_selected \MAP_EVENT_AUDIT.txt -U sa -P
sa_password -c
where
•
location_you_selected is the drive and directory with enough disk space to save the
map_event_audit data; for example, e:\MSQL\BACKUP.
•
sa_password is the password obtained by opening a command prompt, changing to the
C:\mvf\bin directory, and executing passkey -M QUERY -u sa.
8. Close the command prompt.
9. In the Query Analyzer, to truncate the map_event_audit table, type
truncate table map_event_audit
10.
Click Execute a query.
AS300 Preparing to Upgrade Guide—IMPAX 4.5, 5.2, 5.3,or WEB1000 to IMPAX 6.5.3 106
Agfa Company Confidential—Subject to Non-Disclosure Obligation