Which of the following is a reason that transaction logs must be backed up frequently?
A)so you don't have to spend time backing up data files
B)frequent backups increase the likelihood of a corrupt active transaction log
C)when the log is backed up, it is truncated
D)the tail of the log increases each time the log is backed up

Question

Quizplus · Accepted Answer

Transaction logs must be backed up frequently because when the log is backed up, it is truncated. Truncation means that the inactive portion of the log is marked as reusable, which frees up space for new transactions. Failure to back up transaction logs frequently can lead to the log becoming full, causing the database to stop functioning until the logs are backed up and truncated.

Which of the Following Is a Reason That Transaction Logs