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]

Reply via email to