Restore master database

IF i restore master db from one SQL Server 2016 Enterprise With SP1  to another SQL Server 2016 Enterprise does it works?

Assume both servers are same edition and same sp level nothing is different?
VijayAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nitin SontakkeDeveloperCommented:
If you could just let us know reason / the rationale behind you are trying to do this, please.
0
Mark WillsTopic AdvisorCommented:
Yes, but you need to really have to do it, with a very good reason....  It holds logins, configs, and a whole lot more - even the humble @@servername et al

If you have info in one instance that you would like in another, then there are ways to copy, and much, much safer than what is essentially a copy of master.

However, it is possible and strongly recommend against it.

Before you start, have a read of : https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-and-restore-of-system-databases-sql-server

Then read : https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-the-master-database-transact-sql

Treat it more like a rebuild : https://docs.microsoft.com/en-us/sql/relational-databases/databases/rebuild-system-databases
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
I will be very very careful about doing that operation.
Even it's technically possible, the results can be very bad as a master database has information about the SQL Server he belongs to.

You didn't explain why do you want or need to perform such operation but I'll guess that the current master database is somehow corrupted and you do not have any backup to restore it to a last know good status. If this is the case, then I'll recommend you to rebuild the master database.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.