Huge SQL Server Log Files

A new twist on the “My SQL Log File is Huge” problem

I did a video years go on the most common causes for this:

But...if those choices don't work, you need to dig deeper.

My local test server this morning showed the image below for why the log file would not shrink on my StackOverflow database. It wasn’t huge, but would not shrink, despite me using all of my tricks and skills

I spent a solid 15 minutes trying to remove/re-add/remove replication until...

I remembered that that Change Data Capture was enabled, which uses some Replication components to work.

Ran this, and it did the trick:

Use StackOverflow
go
EXECUTE sys.sp_cdc_disable_db;
GO

What other things beside this, and lack of backups have you seen that cause SQL Server .LDF files to get out of control?

Get a Free SQL Server Health Check!

https://dallasdbas.com/health-check-offer/

My Recent LinkedIn Posts:

What Olympic sport are you watching? I’m all about the cycling!

Morning Workouts Great concept, difficult execution (for me)

Interesting Stuff I Read This Week

New Boeing CEO Takes the Reins Good luck Kelly! You’re going to need it!

Delta Sued over CrowdStrike Outage which was not their fault, but they should have handled better.

SQL tidBITs:

The SQL Server Performance Dashboard is built into SSMS, and I’ve just started prepping a for a video on it. Great for shops with no tools and you can’t bring in 3rd party scripts.

Share

Please share or forward this to people that might be interested!