Full, differential and log backups are easy to define and easy to get wrong at 2 AM. This animated guide shows which ones to restore, and in what order.
SQL SERVER – Transaction Logs: The Good, The Bad, and The Ugly
Providing a comprehensive understanding of their role and potential issues. Let us learn about Transaction Logs: The Good, The Bad, and The Ugly.
SQL Server 2022 – Managing Virtual Log Files
Too many VLFs slow down startup, backups and recovery. Here is what changed in SQL Server 2022 for managing virtual log files and how VLFs grow.
SQL SERVER 2022 and Instant File Initialization for Log File
This blog post will explore how Instant File Initialization for Log File growth events in SQL Server 2022.
SQL SERVER – Reasons – Not Able to Shrink the Transaction Log
Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.
SQL SERVER – Available Free Space in Data and Log File
Lots of good feedback, I have received on my recent to the point blog posts. Today we will see a script for Available Free Space in Data and Log File.
Recovery Model Changes and the Log Backup Chain
Explain the log backup chain across FULL and SIMPLE changes, inspect recovery LSNs and backup history, and establish a new backup boundary.