Tag: Transactions

• Log Reuse Waits Explained: LOG_SCAN

  

  2014-01-21 - General, Log Reuse Wait, Series, Transaction Log

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

  [more…]

• Log Reuse Waits Explained: REPLICATION

  

  2014-01-19 - General, Log Reuse Wait, Replication, Series, Transaction Log

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

  [more…]

• Log Reuse Waits Explained: ACTIVE_TRANSACTION

  

  2014-01-17 - General, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting ACTIVE_TRANSACTION 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…]

• 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…]