 | Note: Before backing up the database confirm that you have stopped the IMPAX services, emptied and halted all queues, and shut the database down. 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. |
This procedure applies to SQL Server 2005 and SQL Server 2008.
To guard against information loss, back up the database information to 4 mm tapes or disk daily. In case of system failure, the database can then be restored from the copy.
 | CAUTION! If backups are not created on a regular basis, the transaction log fills up and eventually halts the operation of your system. As well, if you do not do an initial manual backup of your database, SQL Server assumes that you do not want transaction logs maintained. If using a tape backup, to ensure that you have up-to-date backups and backups in reserve, change the tape daily. |
To manually back up the SQL database using SQL Server Management Studio
Select Start > All Programs > Microsoft SQL Server.
Right-click SQL Server Management Studio and select Run as.
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.
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.
Right-click database_name and select Tasks > Backup.
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.
To start the backup, click OK.
Exit the SQL Server Management Studio.
To manually back up the SQL database from the command line
At a command prompt, type
sqlcmd -U sa -P sa_password -dmaster
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.