The Barracuda Backup appliance 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.
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
All SQL databases need to be set to Full Recovery Model in order to produce Incremental backups. Otherwise, Full backups are performed on every run.
Use the following steps to set the Recovery Model on your SQL databases to Full:
- Connect to the appropriate instance of the Microsoft SQL Server Database Engine.
- In Object Explorer, click the server name to expand the server tree.
- Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
- Right-click the database, and then click Properties; the Database Properties dialog box displays.
- In the Select a Page pane, click Options.
- The current recovery model displays in the Recovery Model list. Select Full from the list, and click OK to save your changes.