How to reduce log file size and fix to a lower value

How to reduce log file size and fix to a lower value

 

  

Hi Experts

I am having sql 2005 in win 2003 server.
My log file size seems to be 3 GB and it is growing and making the disk
space full.
How to reduce it and fix the same to a lower value ?

Regards
Vijayakumar K
"Vijayakumar K - Engineer(Data Center) - SIS" <vijayakumar.[Email address protected]

___________________________________________________________________________

Visit us at www.sundaraminfotech.in
___________________________________________________________________________

This E-mail may contain privileged information and is intended solely for the addressee, and any disclosure of this information is strictly prohibited, and may be unlawful. If you have received this mail by mistake, please inform us immediately and delete this mail. Any information expressed in this mail does not necessarily reflect the views of SUNDARAM INFOTECH SOLUTIONS. As per SUNDARAM INFOTECH SOLUTIONS's policy, unencrypted mail via Internet is not considered secure.
___________________________________________________________________________

MS Sql Server LazyDBA home page