[thelist] Truncating Transaction Logs SQL Server 2000

Rob Smith rob.smith at lexjet.com
Mon Apr 17 07:57:27 CDT 2006

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?

Rob Smith
rob.smith at lexjet.com
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236

More information about the thelist mailing list