Post reply

Master database/System databases

  • May 6, 2005 at 8:07 am

    #109576

    Is it possible to move master table or any system tables from one instance to another instance in sql server 2000?If possible How can we do this?Thanks in advance for your time.

    Thanks,

    Sree

     

    Thanks,
    SR

  • May 6, 2005 at 8:55 am

    #557377

    Why bother?

    I am sure that you can copy MODEL to another instance, but I'm not sure about MSDB. I suspect that you can move MSDB but don't quote me on it.

    All of my objects in the MODEL database are scripted in any case and that is the approach I would recommend.

    TEMPDB gets recreated everytime the server restarts so you wouldn't bother with that.

    MASTER is specific to the server/instance so I wouldn't even attempt to risk that one.

    As for your user databases, you can move these around to suit yourself.

    LinkedIn Profile

  • May 6, 2005 at 9:07 am

    #557382

    Thanks for you response David.I appreciate your help.

     

    Thanks,

    Sree

    Thanks,
    SR

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

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