I am moving a database from one server to another server (that already has
other databases on it) and need to transfer the following items:

1. user logins - I have both SQL and NT authenticated users for the
database that do not exist on the new server. Is there a way that I can
transfer the login name and password.

2. I have a number of scheduled jobs for the database - is there a way to
transfer these.

3. I have DTS packages - how do I transfer these.

Also, a general question - what is the best way to move these databases. In
the past I have been just making a backup and restoring them to the new
server. I haven't used the attach, detach functionality. What are your
suggestions?


Thanks in advance,

Melissa


Melissa Faga
GIS/DB Manager
City of Redmond
425-556-2134
[Email Address Removed]MS Sql Server LazyDBA home page