if you can wait until tomorrow, i have these scripts at my office to do this....let me know if you still need them....i can email them tomorrow to the list.
tony -----Original Message----- From: Jared Clinton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 8:59 PM To: CF-Talk Subject: RE: Shrinking a SQL7 log file Scott, Check out the DBCC commands, they are supposed to do what you want to do. Although.... large log files can actually indicate non-committed transactions. Maybe a better question would be : Why is the system creating such large transaction log? You may actually have to export data from your db , destroy the original db and recreate then re-import. This is a horrible way to fix a huge log file, but it will work. Regards, Jared Clinton. NEC Business Solutions. -----Original Message----- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 11 September 2002 7:58 AM To: CF-Talk Subject: OT: Shrinking a SQL7 log file Hey gang - Any SQL7 gurus out there who know how to, resonably painlessly and safely, shrink a SQL7 database logfile from 83749234mb down to something reasonable? Any help (advice/instructions, or links to such) would be most appreciated. Replies off-list are fine. Thanks in advance, --Scott ______________________________________________________________________ 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
