• runal_jagtap (10/9/2012)


    Hi Chandan,

    Can you explain more on what should we recommend in normal scenario???

    I am assusming when you say normal scenario, you mean normal backup policy.

    Backup policy or backup plan is based on the application requirement and RTO(recovery time objective). The objective of the backup policy is to minimize the data loss.

    For example if the application requirement is that they cannot afford any data loss more than hour, then you should suggest a plan as below.

    Weekly Full backup(Sunday night)

    Daily differential except Sundays

    Hourly log backup.

    Hope this helps.

    Regards,

    SueTons.

    Regards,
    SQLisAwe5oMe.