I don't think if this anything to do with logins. Be honest I don't
really care about logins. The only issue is takes really long time to
zip and unzip the file.

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

-----Original Message-----
From: OsgoodRick [mailto:[Email address protected]
Sent: Tuesday, July 31, 2007 11:18 AM
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


Make sure all logins are accounted for. It's very common to have them
show up but be disconnected from security. You may need to drop the
users from the database and reset them in security

-----Original Message-----
From: Albert Frazer
[Email address protected]
Sent: Tuesday, July 31, 2007 9: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



========================================================================
======
This communication, together with any attachments hereto or links
contained herein, is for the sole use of the intended recipient(s) and
may contain information that is confidential or legally protected. If
you are not the intended recipient, you are hereby notified that any
review, disclosure, copying, dissemination, distribution or use of this
communication is STRICTLY PROHIBITED. If you have received this
communication in error, please notify the sender immediately by return
e-mail message and delete the original and all copies of the
communication, along with any attachments hereto or links herein, from
your system.

========================================================================
======
The Travelers e-mail system made this annotation on 07/31/07, 11:17:41.





MS Sql Server LazyDBA home page