Specifications

2.
How to Change the SQL Recovery Model
This article refers to all Barracuda Backup firmware, and Microsoft SQL Server 2005, 2008, 2008 R2, or 2012.
® ®
In this article:
Warning Message
Set the SQL Recovery Model
Additional Resource
SQL Server 2012
SQL Server 2008 R2
SQL Server 2008
SQL Server 2005
The Barracuda Backup Server is designed to initially complete a full backup of the SQL Server database(s). Once the initial full backup is
complete, the Barracuda Backup Server can attempt to complete an incremental backup of the SQL Server database. In order for the Barracuda
Backup Server to successfully complete an incremental backup, the SQL Server database(s) must be set to Full Recovery Model. Typically, SQL
Server databases are set to Simple Recovery Model by default.
Warning Message
If an incremental backup cannot be completed, the Barracuda Backup Server reverts to a full backup and a warning
message displays:
The recovery model controls how transaction logs are managed. Before changing the Recovery Model, consult your database administrator to
determine the setting that is appropriate for your environment.
Set the SQL Recovery Model
Simple Recovery Model
If you wish to leave the SQL Recovery Model set to Simple Recovery Model log into the Barracuda Backup web interface, and go to,
the page. On the page, Click the icon for the associated backup schedule. On the page,BACKUP > Schedules Schedules Edit Edit
in the section, select from the drop-down menu. Click at the top of the page to saveSQL/Exchange Backup Full Backup type Save
your changes.