thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Transaction Log

A sequential record of every change made by transactions, used for recovery, rollback and replication.

Definition

In SQL Server the transaction log (.ldf) must be backed up regularly in the full recovery model, or it keeps growing. It is the source for log shipping, availability groups and CDC.

Exam tip

A SQL Server log that keeps growing in the full recovery model usually means log backups aren't being taken.

Related terms