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 can I have Microsoft SQL 2012 truncate its logs after the Barracuda Backup Service backs them up?

  • Type: Knowledgebase
  • Date changed: 3 years ago
Solution #000006566

Scope:

All Barracuda Backup Servers


Answer:
Currently, the Barracuda Backup Service supports two separate (and mutually exclusive) methods to backup SQL 2012 databases:


- The original 'Microsoft SQL Server' object, which relies on both VDI and SQL commands to perform backups. 


-  'Microsoft SQL' object ,which uses the Volume Shadow Copy Service (VSS) to backup databases directly.  VSS does not support log truncation (a limitation of the VSS Writer provided by Microsoft).

 

There are two possible interim solutions for log truncation when the 'Microsoft SQL' object is being used.

 

1. Set up a maintenance plan to truncate the logs through SQL Management studio.  See http://technet.microsoft.com/en-us/library/ms191002.aspx

 

2. Enable the agent to use the former 'Microsoft SQL Server' object to backup SQL Server 2012 and later databases. This can be configured by setting 'vssSqlVersion=20' in the agent's bbconfig.ini file.  The old object will perform incremental backups and truncate the logs. Disclaimer!! the only part that should be copied and pasted is "vssSqlVersion=20", otherwise, this will not work correctly.



Edit the Barracuda Backup Agent


Use the following instructions to edit the Barracuda Backup Agent installed on the SQL Server to use the former Microsoft SQL Server object:


On the Microsoft SQL Server where the Barracuda Backup Agent is installed, open the Services console.

Right-click on the Service Barracuda Backup Agent, and click Stop. The Service is now stopped.

Open the bbconfig.ini file in Notepad as an administrator; the default file location is:

C:/Program Files/Barracuda/Barracuda Backup Agent/config/bbconfig.ini

Set vssSqlVersion=20 under the configuration section in the file. For example:  

[installControl] 

buildNumber=89742 

installedVersion=5.4.00-dbg


 

[configuration] 

nodeGuid={00001001-B0C179DB-B0C179DB-B0C179DC} 

vssSqlVersion=20


 

Save and close the file.

Open Services once again.

Right-click on the Service Barracuda Backup Agent, and click Start . The Status field should display as Started .

VDI is now enabled to implement incremental SQL database backup and truncate log files.



If databases do not appear below the container:

  • The user "NT Authority\SYSTEM" should have Server Roles permissions as the following screen shot shows:













































Additional Notes: 


Further Reading:
http://technet.microsoft.com/en-us/library/ms144284.aspx


Link to This Page: 

https://campus.barracuda.com/solution/501600000013jHGAAY