SQL Server Database Recovery Model Part 2

Deciding on the right Recovery model
Now that we know the differences between the three types, it’s essential to know which one to choose. Below are a few guidelines on selecting the most appropriate Recovery Model for your database:

Simple
Select the Simple Recovery model if:
• Your data is not critical and you don’t mind losing some data from the log.
• Space is limited to log transactions.
• Data is derived from other data sources and can be easily recreated.

Bulk-Logged
Select the Bulk - Logged Recovery model if:
• Data is critical, but logging large data loads slows down the system.
• Database is subject to periodic bulk operations and most of it is done during off hours.

Full
Select the Full Recovery model if:
• You need the ability to do a point-in-time recovery.
• Data is critical and no data can be lost.
• You are willing to incur the administrative costs of transaction log backups.