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
> >
> >
>
>

Relevant Pages

  • Re: logs
    ... Dave L ... By backing them up. ... If you don't require regular log backups ... then select the simple recovery mode, but bear in mind that you will ...
    (comp.databases.ms-sqlserver)
  • Re: limit the sql log size
    ... If you are in FULL recovery mode you need to issue regular Log backups to free and reuse the space in the log. ... We had a log several months ago that was over 25 gigs this caused the ... talking tranlog but the sqlserver log under management tab in enterpise ...
    (microsoft.public.sqlserver.setup)
  • Re: logs
    ... If you don't require regular log backups ... then select the simple recovery mode, but bear in mind that you will ...
    (comp.databases.ms-sqlserver)