> We have a sql server 2000 database. Client variables are > enabled and are currently being saved to a database called > CRDB. The log file for CRDB is over 10gig!!! Not doing > anything special, just letting CF handle the client > variables to the database. > > Any ideas why this would be? We don't have that much traffic. > Currently the regular database log file is about 10-20% of > the actual database file. This one is over 15,0000% larger. > Any help would be appreciated. I'm not sure about SQL 2K, but with SQL Server 7, there's a database option called "truncate log on checkpoint", which would prevent the log from getting so big. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
