Hi,

I have around 70 tables all referenced to a main table with a key. I need to archive all the table(s) data every month. At any point of time in a month, there will be 3 months worth of data available. When requested I should be able to restore the data for the previous month(s), based on the request.

How can I go about doing this? How do I archive just 1 months data from all tables. As far as I remember there is no date field in the main table.

Any suggestions on this is welcome.

Thanks in advance.