The log kept growing and sys.databases showed REPLICATION as the reuse wait. Here is how I found why the transaction log in snapshot replication was not reused.
SQL SERVER – Huge Transaction Log (LDF) for Database in Availability Group
A reader’s database in an AlwaysOn availability group grew a Huge Transaction Log of 230 GB with error 9002, AVAILABILITY_REPLICA. Here is what to check.
Tracking sp_configure Changes Through Error Log Messages
Someone changed a setting and nobody admits it. Here is what the SQL Server error log keeps, and what it never records.
SQL SERVER – Basic architecture of Transaction Logs
The SQL Server transaction log works like a string of log records, each with an LSN. My simple notes on the basic architecture of transaction logs.
SQL SERVER – Understanding the Basics of Write Ahead Logging (WAL) Protocol
Doing the basics right matters. Here is a simple, story-driven explanation of the Write Ahead Logging (WAL) protocol that keeps SQL Server transactions safe.
Autogrowth Settings: Why 1 MB and 10 Percent Still Hurt
Inspect autogrowth settings across database files, review retained growth events and VLFs, and choose tested fixed-size increments.
SQL SERVER – Script: Knowing Data and Log Files Are On the Same Drive
At GIDS I talked about keeping data and log files on separate drives. Here is a script that shows which databases have data and Log Files on the same drive.