Under CF5, a timeout of "0" meant a permanent (no timeout) database connection -- don't know for sure if this holds under CFMX, but since you're on CF5, that's the problem.
But if you're working on a nightly backup, I wouldn't rely on the connection timeout. If the db is unavailable during the backup, your site isn't really available either (at least the db portions). You could use xp_cmdshell to stop the coldfusion server (ensuring that there are no remaining cf db connections) and then run the backup and restart the cf server all in T-SQL (assuming appropriate permissions, etc.) Depends on the size of the backup -- but shouldn't be more than 5 minutes. Of course, that's a long time on a 24x7 site. But honestly, SQL 2000 can backup a database while it is in use. Backups can fail if you're creating/deleting database files or shrink commands, but just having an active connection isn't a dealkiller. I'm running one right now on a reporting database (2.5 GB) while a couple of huge reports are running (11 table joins, including composite keys of text fields -- don't ask) and it's working fine. There are 34 connections, 5 users, and about 8 running/runable tasks. And I'm doing sp_who, etc to check these things while the backup is running. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ----- Original Message ----- From: "Smith, Matthew P -CONT(DYN)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 9:18 AM Subject: MS SQL obdc data source timeout settings > A couple of questions regarding connection timeout settings for a MS SQL 2K > obdc data source: > > While trying to run a backup job on the db, the job said that it was unable > to go into single-user mode because of the cf connection. This was without > any activity on the site, and profiler shows that the CF account was > maintaining the connection. After checking the data source settings in cf > administrator, I noticed that the connection timeout was set to 0 minutes > for several of the data sources. > > So, would having the connection timeout set to 0 cause CF to maintain the > connection indefinitely? > > What is the recommended setting for connection timeout? This is a > low-to-medium traffic intranet site. > > Also, this is for a CF5 server. Are the recommended settings different for > CF MX? > > Thanks, > Matthew P. Smith > Web Developer, Object Oriented > Naval Education & Training Professional > Development & Technology Center > (NETPDTC) > (850)452-1001 ext. 1245 > [EMAIL PROTECTED] > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
