Hopefully this makes it to the list. I've been unable to post for quite some
time and had to set up an alternate method of subscribing on an email
address that isn't my work email.

Anyway, Albert, I do this all the time, using pretty much your method. I am
somewhat limited in how I can move files. ftp is not currently an option.
I've been using xcopy to move the files (via a batch file called from dts)
even though that's not at all optimal. My experience has been that xcopy
isn't reliable. There are times when the batch file transfer simply doesn't
complete. We don't have a huge pipe between the domains so it can take a 1-
2GB file four hours to transfer. It's possible you weren't patient enough.

What method are you using to move the files? In the past, I've found ftp to
be less failure prone.

Carolyn J


I need your help in this.

I want to backup database on one server and restore it on another server
located on different network.

So far I've tried this:

1. backup database

2. zip it with 7zip software

3. move the zipped file to another server

4. unzip it

5. restore it on another server



I automated everything by creating bat files with appropriate commands and
put everything as separate steps in one job. I started the job last night at
about 11pm and it was still running when I checked at 3:30am this morning,
so I killed it.



Any suggestions, ideas?


MS Sql Server LazyDBA home page