Storm season is back, bringing with it the potential for significant weather events. If you have clients in areas prone to infrastructure disruption, visit the Disaster Recovery Resources guide for preparedness information. Datto recommends performing proactive disaster recovery testing to mitigate potential downtime. See our articles about the importance of disaster recovery testing and Preparing For A Cloud Virtualization Test: Policies, Procedures, And Partner Responsibilities to learn more. For live updates, follow @datto on Twitter.

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



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

Original Article from:


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


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:

Transaction Log Truncation:

Shrinking the Transaction Log:

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!