Reputation: 9094
we have created a maintenance plan to backup our databases and transaction logs every night. I noticed that when the backups are completed, the transaction logs are not getting truncated. I checked the settings and I don't see any option. we are using sql server 2008.
Upvotes: 1
Views: 8932
Reputation: 21
The act of backing up the transaction log should automatically truncate it. See below for information and possible reasons that would prevent this:
Upvotes: 2