> 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
