It was hung on the zip process

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

-----Original Message-----
From: Bowman Rita A. [mailto:[Email address protected]
Sent: Tuesday, July 31, 2007 12:16 PM
To: Albert Frazer
Subject: RE: restore database on another network

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


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