Hi,

Our RT3 system has Attachments table with size about 300GB. We'd like to
clean it by removing old records with files. The rt-shreder can do this job
properly I guess. But there is no way to specify query criteria there. Even
direct delete query is failed.

Does somebody can suggest how to clean Attachments table?

BTW, IMHO it's bad idea to store files in the database cause it isn't
scalable solution and it's very difficult to upgrade/backup/restore DB.

-- 
Cheers,
Michael
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
*  Chicago, IL, USA — September 26 & 27, 2011
*  San Francisco, CA, USA — October 18 & 19, 2011
*  Washington DC, USA — October 31 & November 1, 2011
*  Melbourne VIC, Australia — November 28 & 29, 2011
*  Barcelona, Spain — November 28 & 29, 2011

Reply via email to