Following the recommendation of a daily full database dump, with hourly transaction log dumps, ensures that your system can always be recovered to the state of the last transaction log dump and that data loss is minimized. The following strategy is recommended:
- Database Backup—Daily from live database to hard drive (database dumps). Daily tape backups of database dumps are recommended.
- Dumping Transaction Logs.
- Hourly: Append to existing log.
- Nightly: Overwrite the existing log (use the INIT option if using T-SQL to define backup operation).Info: Failure to run transaction log dumps during the day means that a hard crash during the day may result in the loss of ALL data since the last full backup.