Database-logging status
You must use transaction logging with a database to take advantage of any of the features listed in Database server processes that require logging.
- Unbuffered transaction logging
- Buffered transaction logging
- ANSI-compliant transaction logging
- No 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 How the database server uses shared memory and Flush the logical-log buffer.