Maybe you can purchase Winzip 10? It is pretty cheap and you can
schedule the zip operation. I think we paid $36 per license for 4 or
more. I have not had any trouble with this software.

Albert Frazer wrote:

>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
>
>
>
>---------------------------------------------------------------------
>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