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


MS Sql Server LazyDBA home page