Hi Steve ,

the current infrastructure is a cluster hosted on 2 HyperV servers with Sql server 2014 installed and iSCSI disks attached as shared disks to host the data of...

USE BOSPSe

GO

BACKUP DATABASE [BOSPSe]

TO DISK = N'E:\Backups\BOSPSe.bak'

BACKUP DATABASE [BOSPSe]

TO DISK = N'E:\Backups\bospsediff.bak'

WITH DIFFERENTIAL;

GO

BACKUP LOG [BOSPSe]

TO DISK = 'E:\Backups\BOSPSe.log'

WITH NORECOVERY

there are the 3 scripts running for backup

You don't have "copy_only" enabled as an option on the log backups do you?

This will never mark the log as re-usable.

Inherited very large AOAG setup once where the previous...

OK after reading the article i pretty much understand the way the logs work...

the option to truncate the log file is deprecated after sql server 2008, so the way is...

Thank...

do you have a detailed link to read in order to apply the setting to my prod env?

Thank you!

well i might be mistaken but if i run

select * from sys.dm_db_log_space_usage;

the total log size in mbs is MUCH bigger than the used log space in bytes (this is why...

creating a separate drive for only log backups and taking transaction log backups 8 times a day would help?

BACKUP LOG 'name' to disk = 'path'

is this going to truncate the...

well the program which relies on the sql server is gathering everyday through email alerts from 100+ ships and store them to the database, the data which are stored in...

the growth is linear... 35-45GB of logfiles everyday

Thank you for your reply,

i have a job which checks for index fragmentation every day but the results are pretty low something like less than 700 pages (the fragmentation levels...

yes we are running 1 full backup every night 4 differential during the day and 8 transaction log backups

but the logs are not truncated , only when using the script...