Gabud, Also consider deleting the records from the Email Error Logs form. If you have 3 mil in the messages form, the error log is likely bloated as well.
The other question is do you need the e-mail messages to be stored in the form for a period of time? If not (and you may already have done this) you can configure the system to delete the e-mail after it has been sent. This is done on the E-mail system Configuration form. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brittain, Mark Sent: Wednesday, December 09, 2009 8:48 AM To: [email protected] 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 to "Delete from Source" and set a time like an escalation. In a case like this (3M records) first I find the date of the first record (e.g. 9 Dec 2007) and set up the qualification as 'Create Date' < (60*60*24*705). This is two years minus 25 days. Each day after the archive has run I subtract another 25-30 days until I get to the desired number of days which for me is 3 days. Nothing special about the 25-30 days, just like to do small batches. Once you get down to the desired level of days, you can almost forget that it runs. You can run the Archive more then once a day but no less than once an hour. Archive won't start if the previous Archive is still running. FYI Mark ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ex Soundgarden Sent: Tuesday, December 08, 2009 6:57 PM To: [email protected] 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. 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"_ ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

