We use cookies on our website to ensure we provide you with the best experience on our website. By using our website, you agree to the use of cookies for analytics and personalized content.This website uses cookies. More Information
It seems like your browser didn't download the required fonts. Please revise your security settings and try again.

Barracuda Backup

How and when do SQL logs get truncated with my Barracuda Backup Service?

  • Type: Knowledgebase
  • Date changed: 7 years ago

Solution #00004575

 

Scope:

This solution applies to Barracuda Backup Service.


Answer:
When you perform a full backup of your SQL instance, the Barracuda Backup Service will send a command to SQL to let it know to truncate the logs. SQL will then write all zeros to the existing log (it will not change the size of the log). When new data comes in it will then overwrite the zeros with the new data.

 

It is possible, after a long time, the SQL log file could grow to unwieldy size. If this should happen, please refer to this Microsoft article on how to manually shrink the log file(s):

 

http://support.microsoft.com/kb/873235

 

Link to this page:

https://campus.barracuda.com/solution/50160000000I9LBAA0