• Dinesh Asanka (2/8/2010)


    in your senario, you don't need diff backups.

    That's a wrong piece of advise.

    But there are places which has only one full backup for a week. take diff. backup daily mid night. log backups during day time

    Totally depends on his business requirements and the recovery period that they have set to. Differential backups are an added advantage on database recovery at a DR scenario and also it does not lead to confusion. It is better and recommended to have atleast one differential backup during the mid-day.