Post reply

how to migration sql server 2000 master and msdb database to other sql server 2000 between different machine

  • February 6, 2010 at 12:55 am

    #98537

    Dear all

    how to migration sql server 2000 "master" and "msdb" database to other sql server 2000 between different machines ?

    thanks a lot . 🙂

    Best Regards

    Eric

  • February 6, 2010 at 2:12 am

    #1114955

    I wouldn't recommend moving the system DBs from one server to another. What are you trying to do?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 6, 2010 at 2:56 am

    #1114964

    Hello Gail

    I want to clone one same sql server instance and dbs in other machine.

    Have you any other good methods ?

    BR

    eric:-D

  • February 7, 2010 at 2:51 pm

    #1115265

    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!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply