How to move Master DB One server to another server

Question

Hi,

How to move Master DB One server to another server?

ramaprasad

Answer 1

MASTER database is a system database and that is INSTANCE SPECIFIC.
You can only make a new master with your new installation and you can move your login info and other ssql server level infos from one master to other master db.

---

Thanks, Leks

Answer 2

MASTER database is a system database and that is INSTANCE SPECIFIC.
You can only make a new master with your new installation and you can move your login info and other ssql server level infos from one master to other master db.

---

Thanks, Leks

This is incorrect.  You can backup/restore master from one server.  If you are doing a side by side migration, it is easier to backup/restore the system db's than to try and migrate all the information contained in them.

---

Jonathan Kehayias
http://sqlblog.com/blogs/jonathan_kehayias/
http://www.twitter.com/SQLSarg
http://www.sqlclr.net/
Please click the Mark as Answer button if a post solves your problem!

Answer 3

Hi Jonathan,

I dint mean that .. It can be restored to other server ,  but the information contained in them are different . I never wanted RAM to restore master db on other existing master db on some other server. Sorry anyways i should have rephrased the sentence.

---

Thanks, Leks