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 8 years, 8 months ago by Andrew Jackson.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
August 22, 2015 at 11:31 am #503 Score: 0

Stephen West
Moderator

Karma: 4 pts

I use SQL Server and want to know that what are reasons that we may choose full recovery model?

For example I know that when we want to use CDC, or Mirroring must set our database recovery mode to full.

databases of SharePoint are full recovery mode. Can I change them to simple?

August 24, 2015 at 7:14 am #506 Score: 0

Andrew Jackson
Moderator

Karma: 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)
Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.