We are trying to archive our data for the first time in our database. The database is around 250 GB. Our approach is as follows. Create a copy of those tables without any index or constraints. And then dump the old data onto archive tables.And then remove the archive data in main tables.
For this either we can copy everything into archive tables,truncate main tables and then repopulate them. Or copy only necessary data to archive table and delete from main table. Considering the fact that main tables would have index and constraints on them which would make more sense? Also would it be better to disable all indexes before this operation. If so, should I disable clustered index also?