If you are speaking of the error log, you can use set how many error logs to keep in the registry and set SQL Agent to rotate them daily, weekly, whatever. I do not remember the syntax but it is in the Microsoft knowledgebase. We are set to keep 30 days and we rotate daily. Makes for nice small logs that are easy to read.
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. Justin -----Original Message----- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 7:07 PM To: CF-Talk Subject: OT: Large SQL log file Hello all I have an SQL.log file that has grown to approx 2GB. How do I reset the options for this file/Delete it? I have looked in the SQL manager, but cant seem to find were the settings are. I would like to limit what is being logged and to decrease the size of the file itself. Thanks for the help ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
