Database Backup Process

The default backup schedule is
  • Full Database Backup every weekend.
  • Differential Database Backup every day.
  • Transaction Log Backup every hour.
After each backup a restore script (T-SQL) is generated by the database backup automation.

Backup file archive

On a daily basis the backup files are archived to external storage.
The automation maintail a full backup chain on the local storage. That is the latest full backup file, the latest differential backup file and the following transaction log backup files.

Last edited Sep 16, 2013 at 6:25 PM by NielsGrove, version 4

Comments

No comments yet.