What will be the best practice to create DB policies and schedules for MS SQL Backups. As per our standard policy Primary Copy 7 days retention period, AUX copy to DR 8 weeks and then tape backups for 1 year and 10 years.
So how should we create schedules for Daily DB backups, Transaction logs backups every 4 hours. Should we keep separate storage policies for DB and logs backups or they can be on the same.
Any addiditional information will be highly appreciated.