Then u will need to speak to your host. -----Original Message----- From: Dan Plesse [mailto:[EMAIL PROTECTED] Sent: 30 June 2006 20:18 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:245193 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