Why we using full recovery model for database
Stephen West ~
Modified: August 22nd, 2015 ~ ~ 1 Minute Reading
- This topic has 1 reply, 2 voices, and was last updated 9 years, 8 months ago by .
Viewing 1 post (of 1 total)
-
Posts
-
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)
Viewing 1 post (of 1 total)
- You must be logged in to reply to this topic.