Re: How do I reduce the physical size of the file?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 10:54:28 +0100

Use the DBCC LOGINFO commend to see whether the tail of the log is active or not. I've mentioned the
command (as well as a couple of KB articles) briefly at:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"jouj" <jouj@discussions.microsoft.com> wrote in message 
news:233BAB50-5AE8-41A3-B5A2-002FABA25790@microsoft.com...
> Hi,
> I have an MS SQL Server 2000 Database with a huge physical log file (14Gb).
>
> I tried:
> 1-Backup Log <MyDB>
> 2-DBCC SHRINKDATABASE (<MyDB>,10)
> 3-Backup Log <MyDB>.(again)
> The file has not decreased.(from the 14Gb I have 13.3Gb Available Space)
> MyDb file size = 305 Mb.
>
> How do I reduce the physical size of the file?
>
> Any Help is very Appreciated
> Thanks in Advance
> G.H.
>