You must use transaction logging with a database to take advantage of any of the features listed in Database Server Processes That Require Logging.
Every database that the database server manages has a logging status. The logging status indicates whether the database uses transaction logging and, if so, which log-buffering mechanism the database employs. To find out the transaction-logging status of a database, use the database server utilities, as explained in Monitoring the Logging Mode of a Database. The database-logging status indicates any of the following types of logging:
All logical-log records pass through the logical-log buffer in shared memory before the database server writes them to the logical log on disk. However, the point at which the database server flushes the logical-log buffer is different for buffered transaction logging and unbuffered transaction logging. For more information, see Figure 25 and Flushing the Logical-Log Buffer.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]