<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RT data size maintenance</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16850" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=025345713-30072009><FONT face=Arial
color=#0000ff size=2>Hi,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=025345713-30072009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=025345713-30072009><FONT face=Arial
color=#0000ff size=2>be very, very, very careful doing this on DB level, you
should give RTx-Shredder a try, but touching the DB directly is not a good
Idea!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=025345713-30072009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=025345713-30072009><FONT face=Arial
color=#0000ff size=2>Torsten</FONT></SPAN></DIV><BR>
<br>
<p class=MsoBodyText><span style='font-size:8.0pt;font-family:Arial'>Kühne +
Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius (Stellv.), Reiner <span
class=SpellE>Heiken</span> (Stellv.), Bruno Mang, Alfred <span
class=SpellE>Manke</span>, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens <span
class=SpellE>Wollesen</span>, Rainer <span class=SpellE>Wunn</span>,
Sitz: Bremen, Registergericht: Bremen, HRA 21928, <span class=SpellE>USt-IdNr</span>.:
DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: <span
class=SpellE>Contern/Luxemburg</span>, Geschäftsführender Verwaltungsrat:
Klaus-Michael Kühne <o:p></o:p></span></p>
<br><DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>Von:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>Im Auftrag von
</B>Venkateswaran, Subbaraman<BR><B>Gesendet:</B> Donnerstag, 30. Juli 2009
14:18<BR><B>An:</B> rt-users@lists.bestpractical.com<BR><B>Betreff:</B>
[rt-users] RT data size maintenance<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><FONT face="Trebuchet MS" size=2>Could someone please help with an approach
to delete all attachments in RT database earlier than an year (or so)? We are
max'ing out RT database size and would like to perform some cleanup. Or if there
is a better way to do these type of maintenance, please do let us know.
Appreciate your help.</FONT></P>
<P><FONT face="Trebuchet MS" size=2>Thanks</FONT> <BR><FONT face="Trebuchet MS"
size=2>Subba Venkateswaran </FONT><BR><FONT face="Trebuchet MS" size=1>A&T -
App Eng - SEG</FONT> <BR><FONT face="Trebuchet MS" size=1>609 282 7015</FONT>
</P><BR>THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE
PRIVILEGED, CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If
the reader of this message is not the intended recipient, you are hereby
notified that any dissemination, distribution, copying or use of this message
and any attachment is strictly prohibited. If you have received this message in
error, please notify us immediately by replying to the message and permanently
delete it from your computer and destroy any printout thereof.<BR></BODY></HTML>