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)




MS Sql Server LazyDBA home page