http://www.sqlserverfaq.com Has some useful info on this subject.
One thing I did recently was to back up the database, detatch the db files using sp_detatch_db, and reattach just the data file using sp_attach_db, forcing it to create a new log file. This was for a log file that just would not shrink. No good if you want to keep the db on line though :-) HTH, Ian -----Original Message----- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: 13 March 2002 21:06 To: CF-Talk Subject: SQL: Truncating Logs Does anyone know the TSQL for truncating a transaction log? Mind sharing? TIA, Duane ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
