I am doing a similar process without ZIPING anything.
Using Windows 2003 R2, I have set up a DFSR folder on both the
destination and source servers. I have a SQL Server Agent job scheduled
to backup the database to the DFSR folder on the source server with
init. DFSR will only replicate the changes in the file so you get
delta's only, well sort of. On the destination server I have a SQL
Server Agent task that is scheduled later to do the restore.


Rick Romack



-----Original Message-----
From: Bowman Rita A.
[mailto:mssqldba-ezmlmshield-x96914200.[Email address protected]
Sent: Tuesday, July 31, 2007 9:16 AM
To: LazyDBA Discussion
Subject: RE: restore database on another network

We go through this process every night. Look at the job history - what
step was the job on when you killed it? I have found that the zip
portion of the process has a tendency to get hung up more than another
step in the process.

-----Original Message-----
From: Albert Frazer
[mailto:mssqldba-ezmlmshield-x53537342.[Email address protected]
Sent: Tuesday, July 31, 2007 10:54 AM
To: LazyDBA Discussion
Subject: restore database on another network


Hello everyone,



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?



Thanks,



Albert Frazer

Home Decor Products, Inc

www.hdpi.com <http://www.hdpi.com>

732-593-3637 (office)

732-570-4465 (cell)





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


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail message from State Compensation Insurance Fund and all attachments transmitted with it may be privileged or confidential and protected from disclosure. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, copying, or taking any action based on it is strictly prohibited and may have legal consequences. If you have received this e-mail in error, please notify the sender by reply e-mail and destroy the original message and all copies.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

MS Sql Server LazyDBA home page