I want to check if my Data Warehouse historical filegroup backups are valid with my most recent Primary Filegroup backup.
I backup the Primary Filegroup every night but historical filegroup backups may be months old. I know in theory it should all work as long as the historical filegroups remain Read-Only but I want to CHECK.
I hope this makes sense - its a bit hard to get across but I worry that in a disaster my historical filegroups won't restore with my latest Primary backup.