|

Smart Transaction log backup, monitoring and diagnostics with SQL Server 2017

Smart Transaction Log Backups Most DBAs today operating their SQL Server database in full recovery model, schedule their transaction log backups to recur on a specific time interval (every 15 mins) for a highly transactional database to avoid autogrowth of the transaction log files. This works well assuming transactional activity is consistent or predictable throughout…