I am after some very top level advice on an issue. We have several information stores (i.e. file servers, mailbox database servers, databases etc). Some data within these stores have very specific retention policies. I.e. certain mail must be kept for so many years, certain records in databases must be kept for some many years, certain documents on file servers must be kept for several years. Albeit not a backup admin, the backup process will backup these in their entirity and write them out to tape. So all files on a specific drive on a file server would be included in the same backup. All email in all mailboxes would be backed up in the same backup (or the entire mailbox DB), all data in a database will be backed up in the same job.
The other side of the issue is their are also policies on not holding onto personal data longer than neccesary. When you have a mix of data with different retention requirements - how does the retention policy work - without having to configure very specific individual backup jobs for each specific set of records? It sounds a nightmare when the same backup job is backing up a multitude of different types of data in single jobs?