Re: Log file won't Shrink in Simple Recovery Mode

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dave Harper (DaveHarper_at_discussions.microsoft.com)
Date: 08/02/04 

Date: Mon, 2 Aug 2004 12:37:11 -0700

There were 10 open trans in the DB

"Andrew J. Kelly" wrote:

> If there are a lot of VLF's with a status of 2 that means you have
> uncommitted transactions in them. What does DBCC OPENTRAN() say?
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Dave Harper" <Dave Harper@discussions.microsoft.com> wrote in message
> news:5F3AE072-8C13-444B-9C0B-E21BA3C7F717@microsoft.com...
> > Ok, I know there are a TON of threads out there on this but I still can't
> find exactly what I am looking for.
> >
> > I have a 4GB DB with a 1GB log file. Backups are done nightly and written
> to a NAS via UNC path. When I went home on Friday the log was 200MB -- this
> morning it was 1GB. As I stated the recovery model is set to simple so it
> should just reuse itself. I issued a DBCC loginfo to see that each part of
> the log was a status 2. I then tried a backup log... with truncate_only and
> backup log...with no_log. This did not reclaim any space.
> >
> > I have exhausted what I THOUGHT I knew about simple recovery. If anyone
> else has an idea, please post!
> >
> > It has always been my understanding that
>
>
>

Relevant Pages

  • Re: Log file wont Shrink in Simple Recovery Mode
    ... Andrew J. Kelly SQL MVP ... What does DBCC OPENTRAN() say? ... >> Andrew J. Kelly SQL MVP ... As I stated the recovery model is set to simple so ...
    (microsoft.public.sqlserver.server)
  • Re: disk I/O tool
    ... Andrew J. Kelly SQL MVP ... "Jay" wrote in message ... Just one question, when building a cluster, is there an alternative to a SAN? ...
    (microsoft.public.sqlserver.server)
  • Re: Slow during Inserts
    ... http://www.support.microsoft.com/?id=q224587 Troubleshooting App ... Disk Monitoring ... Andrew J. Kelly SQL MVP "James Juno" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Performance really poor if calling data from sql clients
    ... What is the compatibility level of the db? ... Andrew J. Kelly SQL MVP ... profiler to see what is happening on the sql server end. ...
    (microsoft.public.sqlserver.clients)
  • Re: Table size and sp_spaceused
    ... It's just that reindexing does nothing for blobs in 2000 but I am pretty ... Andrew J. Kelly SQL MVP ... "John McLusky" wrote in message ...
    (microsoft.public.sqlserver.server)