Solved

Moving master Database to new instance

Posted on 2012-04-05
2
250 Views
Last Modified: 2012-04-06
I have created a new SQL server installation. It had created the default master, model and tempdb databases. Now I would like to bring all my databases from the production environment to this one. However, I also want to ensure that I bring the master, and model databases from my prod environment. So will it be possible to overwrite the master and model databases of the new SQL server installation?

This way I hope I can ensure that I have all of my logins and every other deails intact. Does that make any sense or is there any other better way? Also there are a lot of stored procedures created in master database of the production environment. So dont you think getting this to the new sql installation would be the best way?

Is there anything that may stop me?

Thanks.
0
Comment
Question by:DoubtMan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Assisted Solution

by:Aeriden
Aeriden earned 250 total points
ID: 37812677
You can do a backup using SQL Backup of the master, model, and msdb databases.  Then restore them on the new installation (I would also back them up before restoring them).  I highly recommend making sure both systems are on the same SQL version and patched the same.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 250 total points
ID: 37814843
The steps to move system and user databases are very well described in this article.  
http://support.microsoft.com/kb/224071

Important note:  Both servers must be on exactly the same version including Service Pack and any hot fixes.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question