Evaluating Logging and Transaction Activity

The following database server usage requirements also 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 very 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.