I usually setup purge tasks (copy to same table in another db) every week or fortnight in low-traffic periods