NetBackup SQL Retention Periods - I may be in big trouble
Windows 2008r2, Netbackup 188.8.131.52.
I was asked to perform a restore of some warehouse timeclock data from SQL backups. I cannot locate any restorable data over 1 month old. In every one of our SQL policies, the "application backup" is set for a retention of 1 month, which explains this. In each policy, I also have a retention of 7 weeks for the weekly backup, and 7 years for the monthly backups. Both of these retentions are "automatic backups". We are contractually obligated to our clients that we have a daily backup, weekly, and monthly, but with our SQL backups, it appears that ONLY the "application backup" has any effect on the retention. Our clients are big, powerful corporations (I promise you are either wearing, eating, or using something right now that came through our databases), and I dont want to be messing around and not retaining their data properly. I am already running 112 individual SQL policies in Netbackup (since each database has its own policy for full backups, and one for transactions logs). I'm REALLY hoping that I dont have to add another policy to capture the "application backup" data for the weekly, and another for "monthly" data. Please help. Ive been Googling, and seeing a few things, but nothing that I "want" to know. :-(