 | 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 2005 and SQL Server 2008.
To guard against information loss, back up the database daily to tape or disk. In case of system failure, the database can be restored from a backup.
 | 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
Ensure that you have done an initial manual backup of your database.
Open the SQL Server Management Studio.
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.
Right-click schedule_backup and choose Properties.
In the Properties dialog, switch to the Schedules tab.
Click New.
In the New Job Schedule dialog, in the Name field, type Daily Backup.
Set other configuration options as appropriate for site requirements.
To apply the changes, click OK.
If you are configuring a disk backup:
Switch to the Steps tab.
Select Edit.
In the Command field, type exec sp_backup_database @dump_device_name='disk_backup1'.
To apply the change, click OK.
To close the Job Properties dialog, click OK.
Exit the SQL Server Management Studio.