SQL Transaction Log Backup Size

[tjdoc]

Hi,
Hopefully this is an easy one, but is it possible to see the amount of storage space used by SQL Transaction Logs?
The backup properties on disk only show .vbk and .vib file sizes, but it would be good to know how much space is taken by the logs.

How is it possible to estimate the storage space needed for SQL transaction logs, based on database size etc?
Our jobs will backup the vm and its .ldf and .mdf files every 24 hours.
TLogs backed up every 5 minutes and truncated.

Also another question (sorry) - if the local repo we are using is hardened Linux and the immutability period is set to 30 days, will I be able to delete transaction logs after only 3 days or so (otherwise I'm keeping 30 days tlogs which again will impact storage space).


Thank you

[PetrM]

Hello,

The only idea I have is to write a script that scans the repository file system and sums up the sizes of all files with the .vlb extension stored in the backup folder. By the way, I think it's a good feature request.

I don't think it is possible to know the log size upfront, as it depends on each specific case, including the amount of changes in the database, etc.

You cannot delete any backups until the immutability period has expired, which is 30 days in your case. Please find more information about log backup immutability on this page.

Thanks!