SQL 2008 R2 Log Files Very Large
Posted on 2015-02-18
Good day. I just noticed that there are a few DBs that have transaciton log files that are very large. Let me detailed my scenario. We have about 30 DBs. Only about 8 DBs have log files that are very large. All DBs are set to Full recovery model. We use Backup Exec 2012 to backup the DBs. We backup full on Friday, Backup Differential once a day (at 1 AM), and backup Incremental three times during the day.
We also have a maintenance plan in SQL that runs once a week a checks DB Integrity, Rebuilds Indexes, and a Maintenance Cleanup (deleting file older than 2 months).
Autogrowth is also set on most all of these DBs (for both the DB and the log file).
I think I got all the info. Let me know if there is any further information that would be needed to provide some assistance.