r/SQLServer • u/danrhodes1987 • 2d ago
Discussion Interested to see peoples MDF/LDF sizes to settle and argument
I’ll cut to the chase. We support a company server side, we do the hardware and vm support plus patching etc and another company supports their proprietary software on one of the said servers. The software they have is backed by SQL.
We ran into an issue this week where the logs disk filled up and placed the database on a separate disk into recovery. It then had to replay the LDF over the MDF for consistency etc.
The trouble is the LDF at that point was 992gb. Yes you saw that correct. And it reported it would finish in around three days…
The MDF is 2.4Tb.
Basically my argument is that if setup correctly the LDF should never be that size given backups happen every 15 minutes.
They said they needed additional space so we gave them an extra 1tb which the used to attach a second log file onto the database. This has since used an additional 400gb for logs.
Can I ask, does this sound right to you guys why are the logs so huge, we can’t just keep allocating more and more storage to logs. Surely the logs should truncate?
Thoughts?
