Simple Recovery Model

a. Simple Recovery Model:

• The "Simple" recovery model is the most basic recovery model for SQL Server
• When you choose simple recovery model, SQL Server maintains only a minimal amount of information in the transaction log. 
• It gives you a simple backup that can be used to replace your entire database in the event of a failure or if you have the need to restore your database to another server.

Assume that there was a hardware failure at 10:45  a.m.  If the database was using the simple recovery model, you would have lost 105 minutes of work.  The latest point at which you can recover the database to is 9:00 a.m, since that was the time the last full backup that was made

Here are some reasons why you may choose this recovery model:

• Your data is not critical and can easily be recreated
• The database is only used for test or development
• Data is static and does not change
• Losing any or all transactions since the last backup is not a problem
• Data is derived and can easily be recreated

Type of backups you can run when the data is in the "Simple" recovery model:

• Complete backups
• Differential backups
• File and/or Filegroup backups
• Partial backups
• Copy-Only backups

How to set Simple recovery mode

ALTER DATABASE dbName SET RECOVERY Simple

GO

Or 

Right click on DB --> Properties-->Options