Home » Topic » Why we using full recovery model for database

Why we using full recovery model for database

Stephen West ~ Modified: August 22nd, 2015 ~ ~ 1 Minute Reading

Home › Forums › Why we using full recovery model for database

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • August 22, 2015 at 11:31 am #503 Score: 0
    Stephen West
    Moderator
    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
    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.