Home Forums SQL Server 2008 SQL Server 2008 Administration Backup and Transaction Log Maintenance RE: Backup and Transaction Log Maintenance

  • January 7, 2013 at 9:56 am

    #1574406

    Craig,

    The best way to go about it is to find the SLA/RTO and create a backup plan based on it. For example if your SLA requirement is for 2 hours data loss, then create a backup plan as such:

    -Weekly Full Backup

    -Daily Differential

    -Log backup every 2 hours.

    SueTons.

    Regards,
    SQLisAwe5oMe.