Controlling log file size

My log file size is 38 GB and database file is only 1.5
GB. Only 8 GB space is left to cover the entire disk
space. I backed up the log file and shrink the database
to 10% but it released only 3 GB disk space. What would
be the best way to further reduce the log file size and
control the growth at this point?
Thanks in advance...Hi Jessica,
It should work if u have done exactly as shown in the
below KB
INF: Shrinking the Transaction Log in SQL Server 2000 with
DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;272318
Also do a frequent transaction log backups to over come
this . You can also turn the Database from FULL recovery
to SIMPLE recovery if your data is not critical so that
the log is truncated immediately.
There are some other pointers on MS site which tell why a
Tran. log grows rapidly.
HTH
--
Regards
Thirumal
www.thirumal.com
>--Original Message--
>My log file size is 38 GB and database file is only 1.5
>GB. Only 8 GB space is left to cover the entire disk
>space. I backed up the log file and shrink the database
>to 10% but it released only 3 GB disk space. What would
>be the best way to further reduce the log file size and
>control the growth at this point?
>Thanks in advance...
>.
>