Re: Database LDF file

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 11/29/02 

From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Fri, 29 Nov 2002 08:24:47 -0500

In addition to that you need to either set the recovery mode to Simple or
issue regular Log backups to keep it from growing so big again. 

-- 
Andrew J. Kelly
SQL Server MVP
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se>
wrote in message news:#jdG5X5lCHA.2828@tkmsftngp04...
> Check out DBCC SHRINKFILE. Also make sure you do regular BACKUP LOG.
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver>
>
> "Pupo" <123star@libero.it> wrote in message
news:O55GjT5lCHA.2260@tkmsftngp07...
> > Hi,
> > I see that the .ldf file of a my database has a huge dimension.
> > How i can resize or delete this file so it doesn't full all my HD?
> > Thank Pupo
> >
> >
>
>