Re: Copy Data..

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 05/28/04 

Date: Fri, 28 May 2004 21:16:46 GMT

Hi

The problem seems to be your connectivity to the remote server rather than a
database problem!

You don't say how big your backup files are is or what method you use thr
retrieve it? If you can use FTP then you may wish to look a download manager
program that can resume from the point it was aborted (I can think of any
names at the moment).

Your outsourcer should be backing up the database regularly as part of your
disaster recover plan, maybe that could be extended to sending a copy to
yourselves? Having a copy of the database to restore may not be the only
thing that you need to do when the server goes down!!

John

Adam" <adoeler@sharklogic.com> wrote in message
news:bvNtc.5672$9q1.5647@news20.bellglobal.com...
> Hello, im having troubles copying data from our hosted remote server, to
our
> local server, we want to do this inorder to have a copy of our database
> locally, incase the server ever goes down.. etc.
>
> I have tried, grabbing the *.BAK file and it keeps giving me an error
saying
> the connection is lost.
> I keep trying to use DTS and i get the same problem.
>
> I need something that can copy this data locally fast, and not timeout or
> drop a connection.
>
> any idea??
>
>

Relevant Pages

  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
Loading