Hi,
Try this
backup log db_name with no_log--------------->To Back up the log file
you are going to delete

dbcc shrinkfile(<Logname>,truncateonly)------------------> to reduce the
size of log file

Regards
Sanjeev

Vijayakumar K - Engineer(Data Center) - SIS wrote:
> 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.
> ___________________________________________________________________________
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>


--

MS Sql Server LazyDBA home page