Carolyn,

I'm using basic move command and it is contained in a batch file which I
execute as T-SQL command with xp_cmdshell. The bottleneck definitely is
the zip-unzip step.

Albert Frazer
Home Decor Products, Inc
www.hdpi.com
732-593-3637 (office)
732-570-4465 (cell)

-----Original Message-----
From: dba
[mailto:mssqldba-ezmlmshield-x26839471.[Email address protected]
Sent: Tuesday, July 31, 2007 11:17 AM
To: LazyDBA Discussion
Subject: RE: restore database on another network

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?



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page