SQL Server Performance

Suitable backup and recovery model require

Discussion in 'General DBA Questions' started by sonnysingh, Aug 7, 2006.

  1. sonnysingh Member

    Hi All

    guys.... just want to make sure that I am on the right choice. I need to develop and deploy a backup and recovery model for the database of 20 GB, 5 days in action from 7 am to 8 pm, data is critical, minimum downtime and changes are happen frequently during the above mentioned period of database uses by users.


    please advice...
    regards
  2. Luis Martin Moderator

    Full recovery model.
    Combination of Full backup, differencial backup and transactional backup.
    Take a look of BOL for details.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. satya Moderator

    True and keep the Transaction lgo backup to every 15 minutes for minimal loss.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page