database logs

I am trying to reduce the physical size of a large database log. I have run several utilities - back up with the remove inactive entries from the transaction log checked, the DBCC shrinkfile utility (with a target size and a truncateonly option) and run DB maintenance to remove extra space. The properties of this log file show that it has reduced the size of the file, but the physical size of the file on the server still remains as big as it was.
Any suggestions on how to eliminate all the new free space I have created? I am looking to get the extra space on my server
Thanks.First check for any open transactions using dbcc opentran. Then follow the
steps in
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q272318
For reasons why the log can fill up or grow unexpectadly check out
INF: Causes of SQL Transaction Log Filling Up
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q110139
INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;317375
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Karen" <anonymous@.discussions.microsoft.com> wrote in message
news:34FB692C-3644-45A6-823F-628A5F4C3F18@.microsoft.com...
> I am trying to reduce the physical size of a large database log. I have
run several utilities - back up with the remove inactive entries from the
transaction log checked, the DBCC shrinkfile utility (with a target size and
a truncateonly option) and run DB maintenance to remove extra space. The
properties of this log file show that it has reduced the size of the file,
but the physical size of the file on the server still remains as big as it
was.
> Any suggestions on how to eliminate all the new free space I have created?
I am looking to get the extra space on my server.
> Thanks.