Elinore,
Feel free to delete the records in those tables. Crashing the server? It
depends on how many records you'll be deleting, the size of your
server, and how sensitive you are to user "timeouts," but I doubt you'll
have a problem.
Create a series of escalations that run after 6pm which each delete
chunks of records. Then create more escalations that delete these records
once a week or so.
Drew
Tulsa
On Fri, 25 Jan 2008,
Elinore AR wrote:
Hi All,
We are doing some major clean-up on our old server (ARS 5.1) to unclog
our db and was looking into truncating records from the following
tables (that we have never used as reference for anything as far as I
know)
- Alert Events
- AR System Email Messages
- AR System Email Error Logs
- AR System Email Attachments
Any suggestions? Objections? Hesitations? Tips on how to not crash the
server while attempting to do this?
Thanks in advance!
Elinore
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
