I have an application that acts as a POP3 mail client and writes the message body (with basic header info) to disk as a .txt file. I drop them into a folder hierarchy based on the date, etc which Microsoft Index server indexes (free w/ Windows). Just look for the message via a query based web page...
Not sure if that helps but that's what we did for archiving/searching. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Sanford Whiteman > Sent: Wednesday, October 27, 2004 4:47 PM > To: Rick Davidson > Subject: Re[2]: [Declude.JunkMail] Determining a BCC Recipient > > > I will look into those, the boss wants me to do this on > the cheap, > > the sql idea was first so we could at least say we were > archiving > > the email. > > If you just want archiving for independent audit and to > show good faith, concatenate the Q and D into an > envelope-preserving MBOX for each day. > > However, you have to plan for a real investigation, and > retrievability and simple envelope and body searching > requirements will not be met on the cheap--since maintaining > terabyte databases with _any_ data isn't cheap. Full-text > indexing of such dbs also not a small project no matter > what the driver. FTR, dtSearch web costs, I believe, 1000 > bucks ( + server + storage + labor ). > > --Sandy > > > ------------------------------------ > Sanford Whiteman, Chief Technologist > Broadleaf Systems, a division of > Cypress Integrated Systems, Inc. > e-mail: [EMAIL PROTECTED] > > SpamAssassin plugs into Declude! > > http://www.mailmage.com/products/software/freeutils/SPAMC32/do > wnload/release/ > > Defuse Dictionary Attacks: Turn Exchange or IMail mailboxes > into IMail Aliases! > > http://www.mailmage.com/products/software/freeutils/exchange2a > liases/download/release/ > > http://www.mailmage.com/products/software/freeutils/ldap2alias > es/download/release/ > > --- > [This E-mail was scanned for viruses by Declude Virus > (http://www.declude.com)] > > --- > This E-mail came from the Declude.JunkMail mailing list. To > unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > type "unsubscribe Declude.JunkMail". The archives can be > found at http://www.mail-archive.com. > --- [This E-mail was scanned for viruses by Declude Virus (http://www.declude.com)] --- This E-mail came from the Declude.JunkMail mailing list. To unsubscribe, just send an E-mail to [EMAIL PROTECTED], and type "unsubscribe Declude.JunkMail". The archives can be found at http://www.mail-archive.com.