Multiple choice technology web technology

You perform a full backup of the Adventure Works database that completes at midnight. Differential backups are scheduled to run every four hours beginning at 04:00. Transaction log backups are scheduled to run every five minutes. What information does the transaction log backup created at 09:15 contain?

  1. All transactions that have been issued since 09:10

  2. Transactions that have been committed since 09:10

  3. Pages that have changed since 09:10

  4. Extents that have changed since 09:10
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Transaction log backups contain only committed transactions since the last log backup. Uncommitted transactions are not captured because they may roll back. Option A is wrong (not ALL transactions), C and D describe differential backup behavior, not log backups.

Keep practicing — related questions