It was an oversimplification. Didn't feel like typing then, don't mind now... the problem with truncate logs at checkpoint is that you will only be able to restore until the time of the last backup as there will be no transaction logs to roll forward to get you completely up to date. Any database that is worth backing up, probably should not use this feature, with the caveat that if you have to do a mass bcp or select into, you may want to use it temporarily to prevent filling the transaction logs and then when finished, turn it off and run a full backup immediately so that the transaction log dumps will work again.
This of course gets into a discussion of backup strategies and how often to run full backups and log dumps. We typically do daily full backups and dump the logs every 15 minutes. As the db gets bigger the full backups take longer and longer and one may want to do them less and look for slow times. Justin -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 10: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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
