Personally I did not keep the keys and indexes in my archive db since I want to minimize the time taken to push data into the archive. As far as...

I ended up getting a pretty reasonable solution to this problem. Basically for large tables I copy the data I want to keep into a temporary table and then truncate...

Yeah, cheers for the help.

Yeah I think I will try this out to see what the total downtime would be.

Not a bad idea duplicating the database and switching over once cleaned up. Only problem is there will be new data in the original database by the time it comes...

2005 standard