At a minimum
Basically do a full back up once daily after that is finished do a overwrite on the transaction log , set this up as a job. Do it off hours.
Then set up a job to append to the transaction log hourly.
----- Original Message -----
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Saturday, September 27, 2003 9:27 PM
Subject: Re: Transaction Log (SQL Server 2000) keeps filling up
It sounds like you're not checkpointing your transaction log and therefore
it's growing out of control. This should fix your problem:
- Right click the database and select "Properties".
- Then select the "Options" tab.
- Make sure that the "recovery model" mode is set to "SIMPLE".
-Novak
----- Original Message -----
From: "E Creese" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, September 27, 2003 7:06 PM
Subject: Re: Transaction Log (SQL Server 2000) keeps filling up
> You got a database issue
> ----- Original Message -----
> From: Peter Tilbrook
> To: CF-Talk
> Sent: Saturday, September 27, 2003 9:08 PM
> Subject: Transaction Log (SQL Server 2000) keeps filling up
>
>! ;
> [Macromedia][SQLServer JDBC Driver][SQLServer]The log file for database
> '#######' is full. Back up the transaction log for the database to free
up
> some log space.
>
> I keep getting this annoying error message and it appears to be a rogue
> template being CFSCHEDULED. Server is CFMX updater 3. Has anyone else
had a
> similar issue? I'm deleting the templates that could be causing it to
see
> what happens.
>
> Peter Tilbrook
> ColdFusion Applications Developer
> ColdGen Internet Solutions
> Manager, ACT and Region ColdFusion Users Group (http://www.actcfug.com)
> 4/73 Tharwa Road
> Queanbeyan, NSW, 2620
> ! ; AUSTRALIA
>
> Telephone: +61 -2-6284-2727
> Mobile: +61-0439-401-823
> E-mail: [EMAIL PROTECTED]
>
> World Wide Web: http:/www.coldgen.com/
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
