Ok it's late in the day and I've obviously overlooked the obvious here :) I was trying to run this query via https and this box had a selSSL cert installed on it, which is what was giving me trouble connecting via the Enterprise Manager. I'll deal with that later but at least the RESTORE ran under http.
Thanks again Jochem and Dave. By the way Dave, I haven't had the chance to work with anything I picked up in your class last week. Cam back and as always after a week away, the to-do-list was a mile long. Bob Imperial -----Original Message----- From: Imperial, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2008 3:52 PM To: CF-Talk Subject: RE: Need help with restoring from .bak Thanks for the heads up Dave, now that I've take care of that I have a new error. Progress I guess :) now I get [Macromedia][SQLServer JDBC Driver][SQLServer]Exclusive access could not be obtained because the database is in use. I'm a little confused here, is the reference in the error to the db I am attempting use to initiate the connection with, or the db I am trying to restore? As far as I can see the db I'm using here to initiate the connection is not being used by anybody at the moment. Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
