Hi,
I've logged a support case in Veeam however it's been 2 days now and there's not even a single response
We've a backup job running daily on an SQL server and lately I've noticed it keeps getting out of space. I've already turned on the options for log truncation and
even when the job finishes running, i can see the Log Truncation process succeeded, however when i checked the .ldf and .mdf log files, the log file size stayed
the same. Shouldn't the file size be reduced?
-
- Lurker
- Posts: 2
- Liked: never
- Joined: Dec 06, 2018 3:04 am
- Full Name: dylan wu
- Contact:
-
- Product Manager
- Posts: 14914
- Liked: 3109 times
- Joined: Sep 01, 2014 11:46 am
- Full Name: Hannes Kasparick
- Location: Austria
- Contact:
Re: .ldf and .mdf log files size not reducing
Hello,
this should not happen... could you please tell us the case number? You also have the chance to escalate on your own by clicking on "talk to manager".
Best regards,
Hannes
this should not happen... could you please tell us the case number? You also have the chance to escalate on your own by clicking on "talk to manager".
Best regards,
Hannes
-
- Influencer
- Posts: 24
- Liked: 23 times
- Joined: Feb 04, 2019 10:08 pm
- Location: Germany
- Contact:
Re: .ldf and .mdf log files size not reducing
MSSQL does not automatically shrink MDF and LDF files. Instead it just markes it free internally.
You can see this behaviour by rightclicking on your database, select tasks shrink > files.
In the window that pops up select file type "Log"
About half way down you can see the filesizes. Upper is the current allocated space aka the filesize on disk. The lower one tells you how much of that file is actually used by mssql.
Infos about that can be read up here: https://theitbros.com/truncate-sql-serv ... tion-logs/
You can see this behaviour by rightclicking on your database, select tasks shrink > files.
In the window that pops up select file type "Log"
About half way down you can see the filesizes. Upper is the current allocated space aka the filesize on disk. The lower one tells you how much of that file is actually used by mssql.
Infos about that can be read up here: https://theitbros.com/truncate-sql-serv ... tion-logs/
Who is online
Users browsing this forum: No registered users and 23 guests