No it's on a shared server so I have little control and special backup recovery is charged extra. Maybe I need a new ISP?
Lee On Fri, 18 Feb 2005 13:53:49 -0600 "Eric Creese" <[EMAIL PROTECTED]> wrote: > can you not make a back up of the db and FTP the bak >file to your server or set up a job that could right the >backup toa remote server? > > -----Original Message----- >From: Lee [mailto:[EMAIL PROTECTED] > Sent: Friday, February 18, 2005 1:29 PM > To: CF-Talk > Subject: Getting SQL Data > > > I have an SQL database that is on a shared server at an > ISP. I would like to keep a daily or weekly copy of the > data locally. When I use the VPN to connect and use SQL > Enterprise manager, using DTS to transfer data always > fails in one way or another. It usually leaves several > tables empty with an unknown error code. Getting routine > backup files from the ISP would be costly. Is there a >way > I could use CF or another tool to transfer my data >locally > without a lot of effort? Some files have over 100,000 > records in them. > > Lee Surma > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195460 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