>What is the best method to handle this kind of requirement baring in mind that we must guarantee recovery.
>
>Best Wishes

YOu could always use a software friendly approach; a program that scan through the records, or selects * from the tables and copies them to another table. Otherwise, without a server database like SQL, I don't know how to handle this.