I need to migrate the DTS, the jobs, users and everything from a
database on a Windows 2000 server (SQL 2000, upgraded from SQL 7), to
another (Windows Server 2003, SQL 2000). The databases that do not
already exist on the new server I can restore those from a backup just fine.

The ones that exist (master, model, msdb) I can't copy over from a
restore. It tells me that exclusive access could not be obtained
because the database is in use.

Is there an easy/straightforward way to get everything - especially DTS
and the batch jobs - from my old server to the new one?

Any advice appreciated.

BC

See this post from yesterday: "Moving a DB from 1 Server 2 another".

HTH

Jerry
"Blasting Cap" <goober (AT) christian (DOT) net> wrote