Installation guide

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.
Scheduling additional SQL database backup jobs
(Topic number: 46983)
8.
Note:
Ensure that you are logged in using the AgfaService account; you cannot log into SQL Server
Management Studio using the Administrator account.
This procedure applies to SQL Server 2008 R2.
After upgrading SQL Server, to guard against information loss, manually back up the database again,
then confirm that you can configure a schedule_backup job.
CAUTION!
If backups are not created regularly, the transaction log fills up and eventually halts the
operation of your system. Also note that you must do an initial backup of your database.
Otherwise, SQL Server assumes that you do not want transaction logs maintained.
A schedule_backup job is automatically installed and enabled with the software package. This backup
is scheduled to run at 12:00 midnight every day. In addition to the schedule_backup job, you can
enable and schedule the differential or incremental database backup jobs, if required.
To configure an additional time to run a database backup at, perform the task that follows.
To schedule additional SQL database backup jobs
1. Ensure that you have done an initial manual backup of your database.
2. If not already started, start the SQL Server Agent service through the SQL Server Configuration
Manager.
3. Open the SQL Server Management Studio.
4.
In the Object Explorer window of the Management Studio, expand server > SQL Server Agent
> Jobs
where server is the name of the SQL Server that the program is running under.
5.
Right-click schedule_backup and choose Properties.
6.
In the Properties dialog, switch to the Schedules tab.
7.
Click New.
8.
In the New Job Schedule dialog, in the Name field, type Daily Backup.
9. Set other configuration options as appropriate for site requirements.
AS300 Upgrade Guide—IMPAX 5.2 or 5.3 to IMPAX 6.5.3 31
Agfa Company Confidential—Subject to Non-Disclosure Obligation