June 29, 2014 at 4:07 pm
Hi Experts,
What exactly is a core differences between master database in SQL 2012 cluster instance and SQL 2012 standalone instance.Is master DB in SQL cluster instance holds any info with respect to sql cluster or they are in OS registry?Can we restore master DB from SQL 2012 cluster to SQL 2012 standalone instance?
Your early response will be highly appreciated.
June 29, 2014 at 8:01 pm
The master database contains configuration and metadata information about the instance and databases. Depending upon your configuration it contains information regarding that config.
You can query certain DMVs to obtain information regarding the cluster. The only requirement noted in BOL for restoring the master database is the instance has to be at the same build level, don't recall any references to configuration. The only thing I can see you might see issues with is the SERVER or INSTANCE name that master database references.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
June 30, 2014 at 4:42 am
Bipsy (6/29/2014)
Hi Experts,What exactly is a core differences between master database in SQL 2012 cluster instance and SQL 2012 standalone instance.Is master DB in SQL cluster instance holds any info with respect to sql cluster or they are in OS registry?Can we restore master DB from SQL 2012 cluster to SQL 2012 standalone instance?
Your early response will be highly appreciated.
It's certainly possible, I've done it temporarily before in emergencies. Question is
Why do you want to do it?
If you're looking to move an instance and are thinking of just moving the system databases across, then that's not the accepted and supported way of doing things.
If you have any encrypted objects in the instance you'll have issues with these for starters when restoring a master database to another server.
The MSDB will likely give you the most issues, this does tie heavily with the instance name, etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply