It sounds like you are referring to the transaction log portion of a database, and you can definitely expect the transaction log for Client variables database to grow very quickly because they are updated on every hit. Database transaction logs need to be checkpointed or cleared on backup or whatever, but they will grow and this one will grow like crazy. Your DBA needs to handle it.
Thanks Mark -----Original Message----- From: John P [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2008 11:51 AM To: cf-talk Subject: client variables log database is huge I suspect that there may be a problem with our ClientStorage_log database as it's currently at 11.5 gigs and has to be cleared out once a month or so. I freed 4.5 gigs of space on this server by moving files off 2 days ago and within 24 hours that space was filled again. Could this be a security hole that is allowing our clientStorage_log db to get filled so quickly? I don't know the size of the clientStorage_log prior to moving the files off the server but it's by far the largest recently modified file in the past 4 days. Coldfusion MX7 server. Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315705 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4