To set a SQL database to the Simple Recovery Model, perform the following steps.
Note: Having a database in this recovery model is required in order to take differential backups (instead of full backups).
- Open SQL Server Management Studio.
- Log into the SQL instance containing the database you want to back up.
- Expand the Databases folder to show the database you want.
- Right-click the database and select Properties.
- In the Properties window, select the Options page on the left.
- Change the Recovery model: field to Simple and click OK at the bottom.