I have a requirement for an automated process to streamline warehouse backups
(some tables only) to only 4 weeks of data for each table archived. I have a
system whereby I apply a suffix to ensure unique table names.

We have alot of old data that builds up quickly. In the near future I will
be deleting uneccessary table and implementing the new approach.

Any ideas or experiences of a similar problem much appreciated.

Marc