Setup archive rule on this email form. You may keep one week email and delete all older records. Running this archive weekly.
By this way, I had since cleaned up testing incident tickets on a production box before roll out. Regards, On 12/9/09, Axton <[email protected]> wrote: > Look into the sql 'truncate table' to empty it initially. David has posted > what you need for the ongoing maintenance of the data. While doing the > initial delete, you probably want to look at the email error logs form, the > email attachments form, and all the other email forms. > > Axton > > On Tue, Dec 8, 2009 at 5:56 PM, Ex Soundgarden > <[email protected]>wrote: > >> ** >> Hi All, >> >> I've been wandering around searching for some tips on how to delete 3 >> million records sitting in AR System Email Messages form. What I''m doing >> right now is just doing it by batch - deleting 10,000 records every now >> and >> then. From the past, I remember doing it directly in the database by >> re-creating the Email Messages table (which eventually dropped all the >> records). I had no problem with this. >> >> I just want to know if there are other ways to delete the records without >> going directly to the db? >> >> Thanks, >> Gabud >> >> >> >> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers >> Are"_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > -- Regards, 刘征 Martin Liu ---------------------------------- Blog: http://martinliu.cn _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

