use dbname
backup log dbname with no_log

then do dbcc shrinkfile


----- Original Message -----
From: "Raj Patel " <mssqldba-ezmlmshield-x80106082.[Email address protected]
To: "LazyDBA.com Discussion" <[Email address protected]
Sent: Tuesday, May 25, 2004 10:31 PM
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