Home Forums SQL Server 7,2000 Administration how to migration sql server 2000 master and msdb database to other sql server 2000 between different machine RE: how to migration sql server 2000 master and msdb database to other sql server 2000 between different machine

  • Gail is correct, It is not best practice to move\restore system databases. If i understood correct you want the same objects on both servers correct? If thats the case here is the easiest way achieve your goal .

    Script out all the objects in source server, the objects you need to script out are.

    Logins, Jobs, Operators, Linked server connections, Alerts, Proxies if exists, Publishers\Subscribers if sources servers is involved in replication.

    Enjoy!

    EnjoY!