Home » Blog » Reply » Reply To: Why we using full recovery model for database

Reply To: Why we using full recovery model for database

Andrew Jackson ~ Modified: August 24th, 2015 ~ ~ 1 Minute Reading

Home Forums Why we using full recovery model for database Reply To: Why we using full recovery model for database

#506 Score: 0
Andrew Jackson
Moderator
1 pt

The simple recovery model is generally appropriate for a test or development database. However, for a production database, the best choice is typically the full recovery model, optionally, supplemented by the bulk-logged recovery model. However, the simple recovery model is sometimes appropriate for a small production database, especially if it is mostly or completely read-only, or for a data warehouse.

Some of reason was these:
CDC (Change data capture)
Point in Time
Database Mirroring
Log shipping
Create Transaction log backup (for critical data)