Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: How to choose the recovery model?

    Hello, everyone:

    There are some explanations on this topic from books and BOL. Could you offer the real experience? Thanks.

    ZYT

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    You have to ask yourself (or rather your users) - How much data can you afford to lose?

    If the answer is none - then you need full recovery

    If the answer is we can lose a day - then use simple recovery model, taking a backup every night.
    Regards
    Dbabren

  3. #3
    Join Date
    Mar 2004
    Location
    NJ
    Posts
    14
    The 2 important options in my opinion are simple recovery and full recovery.
    With simple recovery you can only perform full backups and do not have the ability to perform a transaction log backup so in other words you cant restore transaction logs you can only restore full backups. This is good for systems that it is not critical to have un up to the minute restore.

    With Full recovery mode you can perform full backups as well as transaction log backups. With transaction log backups you can restore them on top of your normal backups with will give you a more up to date restore depending on how often you run the transaction log backup. Basically it depends on the criticality of the system.

    Please let me know if I can assist you further. My aol screen name is michael40378

    Thanks,
    Mike

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •