How to move a single Database from SQL Server instance to new SQL instance

[hvmallick]

Hi,

I want to move one database from the source SQL Server 2000 instance to a new SQL 2000 instance in another machine. I have five user databases in this source SQL instance. How should be my approach to move this single database out of this ? My understanding is restoring this database in the new instance, copying all logins to the new instance and then copying the jobs, DTS packages, alerts, operators only specific to this database will do it. Please let me know if this is exactly what I should do ..

Thanks in advance..

Regards,
Himansu

[rmiao]

Yes, that's what you need to do.

[indyandumi]

Himansu, how do you copy the log ins,and DTS packages

[hvmallick]

You can script out those. These are well documented in Microsoft site: http://www.support.microsoft.com/?id=314546

[rmiao]

You can copy sql logins in dts. For dts packages, just resave them to new server.