Evaluate logging and transaction activity
When planning your backup system, also consider logging and transaction activity.
The following database server usage requirements affect
your decisions about the storage manager and storage devices:
- The amount and rate of transaction activity that you expect
- The number and size of logical logs
If you need to restore data from a database server with little transaction activity, define many small logical logs. You are less likely to lose data because of infrequent logical-log backups.
- How fast the logical-log files fill
Back up log files before they fill so that the database server does not hang.
- Database and table logging modes
When you use many nonlogging databases or tables, logical-log backups might become less frequent.