SQL Server 2005:
I need to archive part of the records in 2 linked tables.
I was planning on copying the tables so they can be used for looking up old records if necessary.
In the tables I am copying, I need to delete all records older than 2 years.
How would I go about that.