SQL Transaction Log too large (80GB)

(0) Share

Report

Posted on by Joe Woltering

12,163

So my primary CRM SQL (2008) database is 67GB. The transaction log is 80GB. This alone seems to be problematic but I'm no SQL expert. I have a maintenance plan that runs nightly after a full database backup which checks the db integrity, reorganizes the db, rebuilds the index, backs up the transaction log, and the shrinks the db (in that order). This, however seems to have no effect on truncating the log and reclaiming drive space. If I run a manual transaction log backup and then shrink files on the log, then my .ldf goes back down to 1Gb.

Any ideas?

*This post is locked for comments