On Wed, Nov 30, 2016 at 12:04 PM, Leslie Luck, Jr. <[email protected]> wrote: > Do not use the same IP address. Use DNS that is what it is meant to solve.
OK ... I've read about the Copy Cluster Roles Wizard, but that apparently doesn't work for SQL. Me, I'm thinking I need to install a new instance (SQL3) on the 2nd cluster; rename SQL1 to SQL1-OLD; rename SQL3 to SQL1; re-present the SAN disk to the new cluster; import those disks to the new SQL1 instance. (and then change the SQL pointers for data disk, log disk, etc). > -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Michael Leone > Sent: Wednesday, November 30, 2016 11:56 AM > To: [email protected] > Subject: [NTSysADM] Advice: moving a SQL 2012 clustered instance from one > cluster to another > > I was talking to my boss, and he's thinking of doing something in a couple > months I've never done before. So I thought I'd get a heads up, and start > asking now ... > > We have a Win2012 R2 cluster, it runs 2 roles - a SQL 2012 instance (call it > SQL1) and a file server instance (called it FILE1). > > We have another separate Win2012 cluster running a separate SQL 2012 > instance (call it SQL2). > > He wants to move both SQL1 and FILE1 over to the other Win2012 cluster, so > that we are left with only 1 cluster, running 2 SQL instances and 1 file > server role. Using the same names and IP addresses. > > What I'm unsure about is the AD aspects. I've read how to uninstall a SQL > 2012 clustered instance; seems straight forward enough. BUT ... > does that also uninstall the AD account that the cluster creates? If not, do > I need to remove anything from AD myself? > (I'm assuming I need to create a new SQL instance on the other cluster, > re-using the same name and IP addresses. I know that process creates new AD > entries, but does it use existing entries if it finds any? Or is that a Bad > Thing to do?). > > Or is there a better or cleaner way to move clustered roles and instances > like this, from one cluster to another? > > > > > > > ________________________________ > > > > Under Florida law, all correspondence sent to the Clerkâs Office, which is > not exempt or confidential pursuant to Chapter 119 of the Florida Statutes, > is public record. If you do not want the public record contents of your > e-mail address to be provided to the public in response to a public records > request, please do not send electronic mail to this entity. Instead, contact > this office by phone or in writing.
