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.