[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
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236




More information about the thelist mailing list