Error: "SQL Transaction Log is Not Running the Truncation Processes"

Follow

Scope

The SQL Transaction Log is not running the truncation processes after a ShadowSnap or ShadowProtect Backup.

Original Article from:http://www.storagecraft.com/support/kb/article/266

Cause

A ShadowSnap or ShadowProtect Backup does not trigger a Database Log Backup.

Solution

This is not a best practice on how to set up a SQL server but an explanation of how ShadowProtect engine interacts with SQL and Different Recovery Models.

Simple Recovery Model

Under a Simple Recovery Model, SQL will truncate the transaction log when a checkpoint is created. There are many factors that can cause a checkpoint to be created.  One of these is a database backup, Any ShadowSnap or ShadowProtect backup will be considered a database backup under the following circumstances:

  1. The SQL VSS writer is installed and enabled.

  2. The Database and Log files are being backup up.

    • Both files need to be backed up in the same job.

    • They do not have to be on the same volume.

Full or Bulk Recovery Model

Under the Full or Bulk Recovery Model the transaction logs are not truncated until a Database Log Backup has been completed. A ShadowProtect backup is not considered a Database Log Backup. If the Full or Bulk Recovery Model is required, using the Microsoft SQL Management Studio to schedule a Transaction Log Backup Task will be required to maintain the Transaction Log size.

Applies to: Windows SQL 2005 | Windows SQL 2008 | Windows SQL 2008 R2 | Windows SQL 2012 

Other Resources

Database CheckPoints: http://msdn.microsoft.com/en-us/library/ms189573(v=sql.105).aspx

Transaction Log Truncation:http://technet.microsoft.com/en-us/library/ms189085(v=sql.105).aspx

Shrinking the Transaction Log:http://technet.microsoft.com/en-us/library/ms178037(v=sql.105).aspx


Was this article helpful?

1 out of 1 found this helpful

You must sign in before voting on this article.

Calling all Partners! We want to hear your feedback! Please participate in this quick survey and help us build a better, more-relevant Knowledge Base!

Want to talk about it? Head on over to our Community Forum!