[dba-SQLServer] Re: Truncate Log On Checkpoint

Paul,

Here is the stored procedure that I include in all my databases to do teh 
log stuff.

CREATE PROCEDURE dbo.TruncateLog
AS
begin
         exec sp_dboption 'clientaware','trunc.log on chkpt.','TRUE'
end
begin
         checkpoint
end
begin
         dbcc shrinkfile(clientaware_log,1)
end

GO

Just replace clientaware with the name of you database and/or log file name.

Robert

At 12:00 PM 5/26/2005 -0500, you wrote:
>Date: Thu, 26 May 2005 13:30:44 +0100
>From: "Paul Hartland" <Paul.Hartland at orridge.co.uk>
>Subject: [dba-SQLServer] Truncate Log On Checkpoint
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID:
>         <14A7AB003EFD444BBB193A23128DA20E264E54 at AL-PRI.Aldridge.local>
>Content-Type: text/plain;       charset="US-ASCII"
>
>  To all,
>
>         I want to be able to turn on the following option in a SQL
>Server 2000 database - trunc. log on chkpt
>         but can't for the life of me see where I do this, I am quite new
>to SQL Server and have never used this option before but think it will
>be quite useful.
>
>         Can anyone help me on this.....
>
>         Thanks in advance for any help.....
>
>
>PAUL HARTLAND