Every Microsoft SQL Server database has a log that records all the transactions and database modifications made by each transaction. The transaction log is a critical component of any database, and understanding and managing this log is a critical part of the database administrator's role. This is particularly true under the full and bulk-logged recovery models, which require backing up the log on a regular basis.
This section also contains essential information about the basic architecture of transaction logs and how to manage them.
.gif) Important: |
|---|
|
To minimize the risk of damage to your transaction log, we recommend that you locate the transaction log on fault-tolerant storage, such as mirrored disks. |
In This Section
- Introduction to Transaction Logs
-
Introduces the transaction log and the actions that it supports, and contains links to more advanced information about transaction logs.
- Recovery Models and Transaction Log Management
-
Discusses the role of the recovery model of a database in transaction log management, how to choose the recovery model for a database, transactions that are minimally logged in the bulk-logged and simple recovery models, and guidelines for switching recovery models.
- Managing the Transaction Log
-
Discusses managing log space, managing long-running transactions, and the factors that can delay log truncation.
See Also