Re: limit the sql log size

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

More importantly why did it get that large to begin with? If you are in FULL recovery mode you need to issue regular Log backups to free and reuse the space in the log. Otherwise consider changing to SIMPLE recovery mode.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Bill_Orova" <nospam@xxxxxxxxxx> wrote in message news:%23rKN2$vpIHA.4848@xxxxxxxxxxxxxxxxxxxxxxx

Hello Gurus
I was wondering other than bouncing the server is there a way to limit
or flush a log when it becomes to large say like 11 gigs
We had a log several months ago that was over 25 gigs this caused the
log to fail to grab some of the entries, this stopped us from verifing a
problem
Is there a method to flucsh or limit the size of the log now I am not
talking tranlog but the sqlserver log under management tab in enterpise
manager??


William Orova


*** Sent via Developersdex http://www.developersdex.com ***

.

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: 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)
  • Re: Database LDF file
    ... 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. ... >> I see that the .ldf file of a my database has a huge dimension. ...
    (microsoft.public.sqlserver.security)