Installation guide

CAUTION!
If backups are not created on a regular basis, the transaction log fills up and eventually halts the
operation of your system.
To back up a database using the Enterprise Manager
1. Select Start > All Programs > Microsoft SQL Server > Enterprise Manager.
2. In the Explorer window of the Enterprise Manager, expand Console Root > Microsoft SQL
Servers > SQL Server Group > <server> > Databases > <database name>
where <server> is the name of the SQL Server that the program is running under and <database
name> is the name of the database to be backed up.
3. Select Action > All Tasks > Backup database.
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.
Ensure that the Verify upon completion option is selected.
5. To start the backup, click OK.
6. Exit the SQL Server Enterprise Manager.
To back up the database from the command line
1. At a command prompt, type:
isql -u <user_name> -p <password> -dmaster
2. To back up the database, type:
backup database <database_name> to <device_name>
where <database_name> is the name of the database you want to back up and <device_name>
is the logical or physical name of the tape/disk device.
Configuring database backup times
A schedule_backup job is automatically installed and enabled with the SQL Server software package.
This backup is scheduled to run at 12:00 AM 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, follow this procedure.
To configure database backup times
1. Ensure that you have done an initial manual backup of your database.
2. Select Start > All Programs > Microsoft SQL Server > Enterprise Manager.
3. In the Explorer window of the Enterprise Manager, expand Console Root > Microsoft SQL
Servers > SQL Server Group > <server> > Management > SQL Server Agent.
where <server> is the name of the SQL Server the program is running under.
4. Double-click Jobs.
IMPAX 6.3 AS300 Configuration Guide 10