Re: safest and fastest way to delete AR Email records

*To:* arslist@ARSLIST.ORG *Sent:* Tue, December 8, 2009 7:06:37 PM *Subject:* Re: safest and fastest way to delete AR Email records ** 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

Re: safest and fastest way to delete AR Email records

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 axton.gr...@gmail.com wrote: Look into the

Re: safest and fastest way to delete AR Email records

...@arslist.org] On Behalf Of Ex Soundgarden Sent: Tuesday, December 08, 2009 6:57 PM To: arslist@ARSLIST.ORG Subject: safest and fastest way to delete AR Email records 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

Re: safest and fastest way to delete AR Email records

...@arslist.org] On Behalf Of Brittain, Mark Sent: Wednesday, December 09, 2009 8:48 AM To: arslist@ARSLIST.ORG Subject: Re: safest and fastest way to delete AR Email records ** HI Gabud, Why not use the Archive feature on the Email Messages form? In the form set the Archive Type

Re: safest and fastest way to delete AR Email records

:37 PM Subject: Re: safest and fastest way to delete AR Email records ** 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

Re: safest and fastest way to delete AR Email records

: safest and fastest way to delete AR Email records ** Hi Axton, I'm not sure where David posted his reply from my question. When you say truncate table, this means that I would directly go to the db to delete records

safest and fastest way to delete AR Email records

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

Re: safest and fastest way to delete AR Email records

discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Tue Dec 08 18:56:56 2009 Subject: safest and fastest way to delete AR Email records Hi All, I've been wandering around searching for some tips on how to delete 3 million records sitting in AR System Email

Re: safest and fastest way to delete AR Email records

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