Sep 18, 2018 · SELECT name, log_reuse_wait_desc FROM sys.databases. Above script will return the name of the database along with the log_reuse_wait_desc. The column displays the …

Feb 9, 2017 · “If you have a transaction log that is not growing, and you’re taking regular log backups, but the log_reuse_wait_desc remains LOG_BACKUP, this is because zero VLFs …

The log_reuse_wait_desc says what the state is before the log can be reused or shrinked. In this case it is LOG_BACKUP , meaning that, to shrink the transaction log, you need to backup the …

Jan 13, 2014 · Is your SQL Server transaction log file growing with a log reuse wait of CHECKPOINT? Read on to find out what is causing this and what you can do about it.

Apr 23, 2025 · To make sure that the transaction log can be reused, confirm that there's no other reuse reason indicated on the database: SELECT log_reuse_wait_desc, NAME FROM …

Nov 8, 2021 · It means that SQL Server thinks that these log records are still required on one of the secondaries. That's not the case, but we can fix it if we'll remove the DB from the AG and …

Nov 13, 2013 · If you have a transaction log that is not growing, and you’re taking regular log backups, but the log_reuse_wait_desc remains LOG_BACKUP, this is because zero VLFs …

Sep 18, 2008 · I was investigating the rapid growth of a SQL Server 2005 transaction log when I found that transaction logs will only truncate correctly - if the sys.databases "log_reuse_wait" …

Jul 28, 2017 · It seems that the easiest way to move the databases is to just restore from the .bak files on the new server. I've tested that this works, aside from the fact the logs of the restored …

Jan 16, 2014 · SQL Server will return a log_reuse_wait_desc value of ACTIVE_BACKUP_OR_RESTORE if it runs out of virtual log files during that time. During a …