I have a table with 3.2 million rows of data in it. I would like to transfer about 2 million rows out of it into an archive table. Then once a month I plan on transfering all records that are over a year old. I would like to know how to accomplish this with the least amount of growth in the log files.
I am using SQL 2000, the database is set to full recovery mode and the log files are backed up every hour.