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"

Reply via email to