I am currently running a Database Archiving project for a company and there’s a little issue which has delayed the progress.
After we archived some production tables, the INDEXES and CONSTRAINTs for that particular table is not present on the storage.
We tried to explain that, Backup and Archiving are different, the INDEXES and CONSTRAINTS are present in backup but absent in ARCHIVING, They insisted that, they would need the CONSTRAINTS and INDEXES on the STAGING server and Archiviing storage for reporting purpose. Is there a way to achieve this?
Best answer by Mike Struening RETIREDView original