Category: Transaction Log

• Log Reuse Waits Explained: ACTIVE_BACKUP_OR_RESTORE

  

  2014-01-16 - Backup, General, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting ACTIVE_BACKUP_OR_RESTORE as reason? Read on to find out what that means and what you can do about it.

  [more…]

• Log Reuse Waits Explained: LOG_BACKUP

  

  2014-01-15 - Backup, General, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting LOG_BACKUP as reason? Read on to find out what that means and what you can do about it.

  [more…]

• Log Reuse Waits Explained: CHECKPOINT

  

  2014-01-13 - General, Log Reuse Wait, Series, SQL Server Internals, Transaction Log

  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.

  [more…]

• Eight Reasons why your Transaction Log Files keep growing

  

  2014-01-12 - General, Log Reuse Wait, Series, SQL Server Internals, Transaction Log

  SQL Server organizes the transaction log as reusable virtual log files. However, there are eight reasons that can prevent their reuse causing the log file to grow. Find out what those reasons are and what to do about it.

  [more…]