Solved

Moving master Database to new instance

Posted on 2012-04-05
2
244 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
2 Comments
 
LVL 9

Assisted Solution

by:Aeriden
Aeriden earned 250 total points
Comment Utility
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
Comment Utility
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now