• The plan I prefer for backups is a nightly full backup and transcation log backup every hour, but it depends on your database size, user activity etc.

    This fits my needs, I don't know if it fits yours.

    I don't like differential backups, because I don't want to restore thousands of backups when I need to get back.

    Hope this helps

    Gianluca

    -- Gianluca Sartori