Log file dosen't shrink

Hi,
In SQL 2k I have a log file of 277.99 MB with space used 57 MB and I'm
trying to shrink it and it doesn't, Any suggestions?
What do you do to shrink it? First of all you need to backup the log file to
truncate it and then you can shrink it. You can look up further info by
looking for Shrinking The Transaction Log in Books On Line.
Regards
Steen
Moshe wrote:
> Hi,
> In SQL 2k I have a log file of 277.99 MB with space used 57 MB and I'm
> trying to shrink it and it doesn't, Any suggestions?
|||Backup the log and then try the shrinkfile. You can check
the active sections of the log using dbcc loginfo(YourDB) .
The status indicates which virtual log files are active
where the value for status = 2. If there are active
transactions at the end of the log, you may have problems
shrinking. Generally, backing up the log and then shrinking
will work.
Check the following article for more information:
INF: Shrinking the Transaction Log in SQL Server 2000 with
DBCC SHRINKFILE
http://support.microsoft.com/?id=272318
-Sue
On Wed, 31 Aug 2005 14:15:10 +0200, <Moshe> wrote:

>Hi,
>In SQL 2k I have a log file of 277.99 MB with space used 57 MB and I'm
>trying to shrink it and it doesn't, Any suggestions?
>
|||Thanks Steen
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:%23hQwvYirFHA.460@.TK2MSFTNGP15.phx.gbl...
> What do you do to shrink it? First of all you need to backup the log file
to
> truncate it and then you can shrink it. You can look up further info by
> looking for Shrinking The Transaction Log in Books On Line.
> Regards
> Steen
>
> Moshe wrote:
>
|||Hi,
Steps you can do to shrink the transaction log file:-
1. Backup the transaction log using the below command.
backup log <dbname> to disk='c:\backup\dbname.trn'
2. Shrink the database log file
dbcc shrinkfile('logical_ldf_name','sIZE_IN_mb_TO_SHRIN K')
Thanks
Hari
SQL Server MVP
<Moshe> wrote in message news:uNuLj0hrFHA.2600@.TK2MSFTNGP10.phx.gbl...
> Hi,
> In SQL 2k I have a log file of 277.99 MB with space used 57 MB and I'm
> trying to shrink it and it doesn't, Any suggestions?
>