Thanks for the suggestions so far. and sorry, Yes I am running SQL 7, IIS4, NT4 SP6, CF5.
But I still can't seem to get to this file. If I go to the database's "truncate log on Checkpoint", it looks like this if for the log for the individual databases " SQLdir/DBname.ldf". They are all under the SQL dir on another drive. But this file "SQL.log" is under the root directory of C:. After looking around SQL manager I didn't see any thing that points to this file. Hopefully some one might have some more suggestions for me to try. Thanks again Rodney -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 7:30 AM To: CF-Talk Subject: RE: Large SQL log file > If you are speaking of your transaction log, you will need to > schedule more frequent backups or dump the transaction logs > periodically. If you set your database to truncate on checkpoint, > it will also prevent the logs from growing, however you will > eliminate your ability restore a damaged database from backup. If I understand correctly, this isn't exactly true - it's an oversimplification. You can still restore databases from backup, whether you're truncating logs on checkpoint or not. If you truncate logs on checkpoint, you can't restore the database from just the transaction log itself. I can guarantee that we wouldn't use the option if it meant you couldn't restore your databases! You're right to point out, though, that using this setting does restrict the ways in which you can backup and restore your databases, and probably shouldn't be selected without that consideration. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
