[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