Copy Data..

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'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'
>|||I assume you are copying the backup file. If that's the case, then you
don't need DTS, a NT job will do the work. In the job, do something like
copy \\your_remote_server_name\share_name\file_name whatever directory
you wanna put it.
First, try it under cmd prompt, if you get the same error, then there's
something wrong with your network connection, you need to fix that.
Eric Li
SQL DBA
MCDBA
Adam wrote:
> 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'
>