October 28, 2015 at 2:12 am
Hello Guys,
I have this situation: -Two nodes cluster with two instances sql cluster 2012 and I need to move all on the new cluster 2012 with finally the same virtually name and instances.
It's possible to restore master order to preserve all security?
Thanks,
Hadrian
October 28, 2015 at 4:03 am
I dont think you need a restore as much as you need a migration of security info from master database from one server to another, can you please confirm if your simply just looking to migrate security info or do you want to restore the master database itself.
If you could explain hy your doing this it might help understand the requirement better.
October 28, 2015 at 4:05 am
Could you not just add in the new nodes to the existing cluster and evict the two old nodes?
October 28, 2015 at 5:11 am
anthony.green (10/28/2015)
Could you not just add in the new nodes to the existing cluster and evict the two old nodes?
Depends if the OS on the existing nodes supports this.
One way if not, would be to run an OS upgrade and then join the new nodes, finally evicting the old upgraded nodes, not even sure it's supported, never tried it, it would be messy to say the least
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2015 at 5:13 am
Hadrian (10/28/2015)
Hello Guys,I have this situation: -Two nodes cluster with two instances sql cluster 2012 and I need to move all on the new cluster 2012 with finally the same virtually name and instances.
It's possible to restore master order to preserve all security?
Thanks,
Hadrian
Perform a clean migration, you'll have the least number of issues in the long run
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2015 at 8:56 am
thanks for your support Our sysadmins wish to install a new cluster on NEW SAN .
KR,
Hadrian
October 28, 2015 at 8:57 am
thanks for your support Our sysadmins wish to install a new cluster on NEW SAN .
KR,
Hadrian
October 28, 2015 at 11:43 am
I strongly do not recommend moving master from one instance to a different one.
Script out your logins (sp_helprevlogin), your linked servers, your config settings, etc
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply