SQL Server Transaction Log Filling Up: ACTIVE_TRANSACTION and ONLINE Index Rebuild
The log backup frees no space and log_reuse_wait_desc says ACTIVE_TRANSACTION. How to find the culprit, whether to kill or wait, and the permanent fix.
The log backup frees no space and log_reuse_wait_desc says ACTIVE_TRANSACTION. How to find the culprit, whether to kill or wait, and the permanent fix.