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
Thanks for the update.
I will discuss this with the client, as we already discussed the difference between Backup and Archiving, but hey are looking at every possibility of having it included in their archived tables..
Let me know if this helps you answer for the customer/project.
Ok, good! I’ll keep you posted on any internal updates.