Re: How to limit the number of sql statements ?

From: Pat Wright (patrick.wright_at_aruplab.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 14:31:04 -0700

you can mark the database to truncate log on checkpoint and that will keep
the log from growing Using enterprise manager right mouse click on the
database and choose options then choose truncate log on checkpoint. With
this you will not have point in time recovery for your backups though. Look
up "point of failure" in BOL and it will give more info.

pat

"Rishi" <anonymous@discussions.microsoft.com> wrote in message
news:e4ce01c40b97$d0bd9870$a501280a@phx.gbl...
> Hi!
> How do we limit the number of sql statements that are
> running at a time in order to prevent transaction log to
> grow infinitely.
> This is urgent!!!!

Relevant Pages

  • Re: 1105 - log file getting full - SQL Server 6.5
    ... I feel that you have the database option "Truncate log of check point" ... is turned off you have to perform the Transaction log backup to clear the ... perform tranaction log backup in frequent intervals. ...
    (microsoft.public.sqlserver.server)
  • Re: trucate log
    ... but it would change the recovery model to Simple - truncate log on ... checkpoint is wat is going on in the Simple model. ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: trucate log
    ... What used to be called "truncate log on checkpoint" is not simple recovery mode. ... Set the database to simple recovery mode if you don't want to perform transaction log backups. ... "Rect" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 6.5 Database Log Size = 0
    ... Perhaps EM show as 0 if you didn't separate the log from the data? ... And perhaps you have truncate log ... on checkpoint on so the log is truncated regularly? ... > Curious as to why EM shows the database log size at 0, when dbcc ...
    (microsoft.public.sqlserver.server)