Skip to main content
Barracuda MSP Partner Toolkit

Setting a SQL Database to Simple Recovery Model

This guide will show you how to put a SQL database into the Simple Recovery Model.  Having a database in this recovery model is required in order to take differential backups (instead of just full backups).



  1. Open SQL Server Management Studiosimplerecoverymodel.png and log into the SQL instance containing the database you want to back up.

  2. Expand the Databases folder to show the database you want.

  3. Right-click on the database and select Properties.

  4. In the Properties window, select the Options page on the left.

  5. Then change the Recovery model: field to Simple and hit OK at the bottom.


  • Was this article helpful?