Sridhar
Sridhar

Reputation: 9094

sql server backup not truncating transaction log

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.screen shot of the maintenance plan

Upvotes: 1

Views: 8932

Answers (1)

BaronGreen.bak
BaronGreen.bak

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

Related Questions