Tag: SQL Server transaction log

TSQL Tuesday #77 – Favorite SQL Server Feature: SQL Server Logging

[callout]It’s T-SQL Tuesday,  the blog party that SQL Server expert Adam Machanic (blog|Twitter) started. This month’s episode is hosted by Jens Vestergaard (blog | Twitter). The topic: Favorite SQL Server Feature. And my favorite SQL Server feature is not any of the latest and greatest ones. That might come as a surprise but at the end of the blog […]

When A Log Backup Does Not Truncate Your SQL Server Log Files In An Availability Group

[callout]This was one of the questions asked during my Monitoring SQL Server Availability Group webinar two weeks ago. If you want to get notified for upcoming webinars, be sure to sign up for my email newsletter.[/callout] There are only two ways that can truncate your SQL Server log files – a checkpoint process when the […]