Backing up and truncating the transaction log is detailed, quite extensively, in both the SQL Server 2000 and 2005 documentation. You just need to RTM. Cheers Ken : -----Original Message----- : From: thelist-bounces at lists.evolt.org [mailto:thelist- : bounces at lists.evolt.org] On Behalf Of Rob Smith : Subject: [thelist] Truncating Transaction Logs SQL Server 2000 : Importance: High : : I hope this is a question for thelist. : : Our transaction log file has reach 11GB and our server is about 600 MB : from filling up, thus halting business. How can I truncate, shrink, or : otherwise reduce the filesize? Is it possible to just create a new : transaction log, and move the 11GB version off to some separate : storage as a back up?