 | CAUTION! Before enabling any differential and incremental backups, ensure that a complete backup has been run. |
This procedure applies to SQL Server 2005 and SQL Server 2008.
Ensure that you are logged on using the AgfaService account; you cannot log into SQL Server Management Studio using the Administrator account.
Differential and incremental backup jobs are installed automatically with the software package. By default, the jobs are disabled. To take advantage of their preconfigured backup schedules, enable the jobs.
The differential job takes less time to complete than a regular backup, as it backs up any differences created since the last full backup was run. The differential backup is set to run at 12:00 midnight every day from Monday to Saturday. Sunday is left open to perform a full weekly backup.
The incremental job backs up the transaction log. This backup is set to run daily at 12:00 noon and 17:00.
Complete and differential backups both start from the beginning of the tape. Ensure that you use different tapes for complete and differential backups. Incremental backups do not require a different tape since that backup appends to the backup at the end of whatever tape is currently in use. To avoid the incremental backup failing due to tape space, periodically change the tape (once a week, for example).
To enable the SQL differential and incremental backup jobs
Open the SQL Server Management Studio.
In the Object Explorer window of Management Studio, expand server > SQL Server Agent > Jobs
where server is the name of the SQL Server that the program is running under.
For the differential job, right-click schedule_backup_diff and select Enable.
For the differential job, right-click schedule_backup_log and select Enable.
Reschedule the jobs if required.