Re: transaction log

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 11:22:37 +0200

Perhaps you are doing defrag during the night? Defrag requires a lot of log records in the log. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"dimitris" <dantoniades@mshf.com.au> wrote in message news:OJ3rFTsFEHA.2052@TK2MSFTNGP11.phx.gbl...
> Hi,
> I have a database size of 2,5 Gb, and I set the transaction log unrestricted
> growth. I backup the database every nite, and next morning the transaction
> log goes up to 4 Gb!. If I restrict the log file (to 800Mb) it will get full
> within a couple of hours.
> If I manually backup the log file and the database and then manually shrink
> it 4-5 times, the transaction log goes back to 130 Mb.
> Any suggestions?
> Jim
>
>

Relevant Pages

  • transaction log
    ... I have a database size of 2,5 Gb, and I set the transaction log unrestricted ... If I manually backup the log file and the database and then manually shrink ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction log problems
    ... IF you have to shrink a database or file it ... sure that you get that database backup on tape or to another machine. ... > We are using SQL Server 2000 on Windows Server 2003 Standard Edition, ... > One of the databases has recently begun showing large growth of the> transaction log and it is causing us some problems. ...
    (microsoft.public.sqlserver.server)
  • RE: Backup in maintenance plan
    ... I selected "Back up the transaction log of the database as part of the ... To ensure an efficient and effective backup and recovery strategy for your ... The transaction log should not be backed up if the truncate log on ...
    (microsoft.public.sqlserver.programming)
  • Re: Restoring from non-truncated transaction log
    ... The transaction log is there to support transactional consistency as well ... as supporting "incremental" backup. ... A database backup contains both data pages as well as the necessary log records (from the ... When your restore a database backup, ...
    (microsoft.public.sqlserver.server)
  • Re: sqlservr.exe taking 90% of memory
    ... On the defrag issue I would stop all non-essential services but specifically ... It might be worth asking this on an sql server specific ... It would be interesting to have SQL Server Manager running and ... the database server every 30 minutes, which if you are having a slowdown ...
    (microsoft.public.windows.server.sbs)