Tag Archives: State: 2 The transaction log for database ‘%.*ls’ is full. To find out why space in the log cannot be reused

SQL Server Transaction Log – Best Practice

Best practices for managing SQL Server Transaction Logs. Steps for better throughput for SQL Server Transaction log. 1. Dedicate a physical disk to your transaction logs.  2.  Defrag the disks on which your tranaction logs reside to get rid of disk file fragmentation.  (requires downtime) 3.  You only need one transaction log.  Put it on a [...]