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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.