I tested this
<cfset hello = st.execute("EXEC sp_dboption 'xxxx_xxx','trunc. log on
chkpt.' ")>
And that worked. However I don't know if it did anything. I logged into
master
<cfdump var="#hello#"> says YES
So I added a little more like ,'TRUE'
<cfset hello = st.execute("EXEC sp_dboption 'xxxx_xxx','trunc. log on
chkpt.','TRUE' ")>
and that failed.
I can't tell if that solved the problem because I increased the log size and
the admin removed
all logs so can anyone test this solution out when the problem happens to
anyone else or
can someone test this solution now email off list to get all the details.
Thanks all who responded Dan
On 6/30/06, Mark A Kruger <[EMAIL PROTECTED]> wrote:
>
> I have a blog post on the topic:
>
> http://mkruger.cfwebtools.com/index.cfm?mode=alias&alias=logfile_obesity
>
>
> It has some useful tips in the comments as well. You may or may not have
> permissions to do this. Probably you will need to talk to your DBA.
>
> -mark
>
>
> -----Original Message-----
> From: Dan Plesse [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 30, 2006 2:18 PM
> To: CF-Talk
> Subject: Re: free up some log space SQL server snafu
>
> Also I don't have permissions do the SQL statements as far as I can tell.
>
> On 6/30/06, Dan Plesse <[EMAIL PROTECTED]> wrote:
> >
> > Snake,
> >
> > "set the database to simple recovery model" can I set this using
> > JDBC???
> > If you can do you have a code example? Dan
> >
> >
> > On 6/30/06, Snake <[EMAIL PROTECTED]> wrote:
> > >
> > > If you set the database to simple recovery model, then the
> > > transaction log is effectively not used (except for essential data).
> > > So you will never end up with a huge one.
> > >
> > > To shrink the existing log, read this, but note the additional
> > > comments I have made at the bottom.
> > >
> > > http://tutorial442.easycfm.com/
> > >
> > > --
> > > Russ
> > >
> > > -----Original Message-----
> > > From: dan plesse [mailto: [EMAIL PROTECTED]
> > > Sent: 30 June 2006 19:05
> > > To: CF-Talk
> > > Subject: free up some log space SQL server snafu
> > >
> > > Does anyone have a "free up some log space" SQL server snafu fix?
> > >
> > > Macromedia][SQLServer JDBC Driver][SQLServer]The log file for
> > > database 'danp564_xxxx' is full. Back up the transaction log for the
> > > database to free up some log space.
> > >
> > > I don't have control over the SQL server I was wondering if I could
> > > block writing to logs or do something in JDBC to overcome this snafu
> > > at all cost.
> > >
> > > Does JDBC have a solution at all?
> > >
> > > Side note:
> > > For the classloading people here. BootstrapClassLoader loads right
> > > into JavaProxy constructor so there is even less need for a CFC to
> > > this task and it should take only three lines of code and no need
> > > for functions or any
> > >
> > > other silly things. I would only classload it one time by saving
> > > classes inside the application scope too. The CFC and example code
> > > does not show this being done.
> > >
> > > Example:
> > > <cfset VoiceManager = createObject("java",
> > > "coldfusion.runtime.java.JavaProxy").init(BootstrapClassLoader)>
> > >
> > > The text to speech CFC is up and running too for flash apps which
> > > make use of MP3 at runtime.
> > >
> > > Dan
> > >
> > >
> > >
> > >
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245185
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
