Melissa,

Response to Q1 and Q2: You can use "Transfer logins Task" and "transfer job
task" respectively in DTS Designer. But be sure to choose only the database
you are moving in the "Transfer logins Task" option so that not all logins
for the server is transferred.

Somehow when I used the transfer job task last time, it did not work for me.
If you only a few jobs and want to move them manually, modify all connection
to the old server to the new server using DTS design GUI then save them onto
the new server.

Response to Q3: If you can detach the database on the old server, you can
detach it then copy the database files to the new server. On the new
database server, create a database with the database name and data and log
file names. Detach the newly created database and attached to the copied
files.

You may want to create the empty database on the new server before
transferring the logins; otherwise, you may run into something like "...user
already in user container.." error when you try to modify the login. You
can restore the database from a backup file, but you may again run into the
user and login mismatch issue unless you create an empty database before
transferring the logins then restore from the backup.

Hope this helps.

Sang Nahm
-----Original Message-----
From: Melissa Faga [mailto:[Email Address Removed] Thursday, August 08, 2002 4:39 PM
To: [Email Address Removed] moving database to new server


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] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page