Let me explain the scenario
1: I have developed a system for an org, the org wants to keep the records for the previous five years, records before these five years must be removed from database, but backup of this removed data should be available on CD or any media.
2: their another requirement is that in future they must have the way to access that removed data, just to query or see the details.
its easy to back up & then remove,
now the problem for me is that how to restore it again on the current database, coz it will disturb the current data by over writing old data,
i dont wanna restore from old backup, then again from new backup.
if i use another database for viewing these removed/backed up data it will be a great time consuming task,
what to do
I hope my problem is clear