Re: transaction log blow up

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/08/04 

Date: Sun, 8 Aug 2004 09:37:38 -0400

JUst one open tran (even for a single update) can impede the normal log
truncation. What does DBCC OPENTRAN() show? 

-- 
Andrew J. Kelly  SQL MVP
"Janet" <anonymous@discussions.microsoft.com> wrote in message
news:205901c47d47$c0d9dd70$a301280a@phx.gbl...
> I definitely would like to maintain transaction log
> backups, so you're correct it is set to FULL.
> Uri, do you have any idea how a log could blow up to 30
> GB? There's no way we had a transaction any where near
> that size.
>
> >-----Original Message-----
> >Janet
> >If don't carry about the data you can set recovery model
> to SIMPLE . I
> >presume you are in a FULL recovery model
> >
> >"Janet" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:20e401c47d07$3c0dd8c0$a501280a@phx.gbl...
> >> Hi, I have a database which takes up 2GB for the .mdf
> >> file. It's on a brand new server that has over 30GB of
> >> free space for the disk where the log file resides. The
> >> other day, the log file expanded to fill all 30GB of
> the
> >> disk. I truncated the log and shrunk the log file. I
> also
> >> increased the transaction log backup so occur every 1
> >> hour instead of every 4 hours which is what I had it
> set
> >> to. I also put a limit 2GB limit on the log file.
> >>
> >> My question/concern is why did the log file get so
> large
> >> in the first place? What are usually some of the
> reasons
> >> why a log for such a small database increase to the
> full
> >> capacity of the disk?
> >>
> >> Thanks,
> >> Janet
> >
> >
> >.
> >

Relevant Pages

  • Re: SQL Server 2000 Performance - 10K vs. 15K
    ... Anyway, what about moving the tempdb log file, since it is on the ... I'm getting a message in event viewer that the tempdb log file is ... plenty of disk space. ... >>> the client on the server, and still have to same issue. ...
    (microsoft.public.sqlserver.setup)
  • Re: Balance I/O
    ... Is it a good idea to decrease the disks which are near 100% busy? ... files on the same disk spindle? ... Redo log file switch frequency (only need to execute this the last ... session to determine the SQL statements executed by the session, ...
    (comp.databases.oracle.server)
  • RE: RAM usage during I/O
    ... > another hard disk? ... Specify a name for the log file and click OK. ... > Windows uses all available physical RAM. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Data lost after rebuilding new txn log after disk failure
    ... Have you performed LOG file backup? ... When the disk is faild you was be able to run BACKUP LOG file WITH NO ... > Is there anything I should be checking on the server? ...
    (microsoft.public.sqlserver.server)
  • Re: How to change DC for Exchange server
    ... I'd take a look at the following article and use the section on Disk ... more as it overwrites the log file when it gets to the end. ... If you have a server problem that requires you to restore ... the Exchange log files are sequential writes. ...
    (microsoft.public.exchange.admin)
Loading