jcool has a good point regarding referential integrity, constraints, and such. This could be an issue, but not impossible. As long as Primary keys stay unique and can never be duplicated.

My suggestion for being able to recover the data is to archive it to another table or set of tables. Maybe even in another database. This will allow you to restore it and back it up seperately.

You may also want to think about creating partitioned views.