make a transaction log backup in order for it to free up space then do
the shrinking or you could enable the auto shrink so as after the
transaction log backup, its size will also decrease.


-----Original Message-----
From: Raj Patel
[mailto:mssqldba-ezmlmshield-x80106082.[Email address protected]
Sent: Wednesday, May 26, 2004 1:02 AM
To: LazyDBA.com Discussion
Subject: Dumping Transaction Log


How to dump transaction log since its growing larger?


---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page