Home | Previous Page | Next Page   Logging and Log Administration > Logical Log > Logical Log >

Logical-Log Files

Logical-log files are not files in the operating-system sense of the word file. Each logical-log file is a separate allocation of disk space that the database server manages. You must always have at least three logical-log files in the logical log.

The database server administrator needs to be concerned with the logical-log files that make up the logical log. If the files are not managed properly, the database server can suspend processing and, in the worst case, shut down.

The database server administrator must choose an appropriate number, size, and physical location for logical-log files. The following sections discuss these topics:

The database server administrator must also ensure that the next logical-log file is always backed up and free. The following sections discuss this topic:

Most database users might be concerned with whether transaction logging is buffered or whether a table uses logging.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]