sql server failover clustering move domain

hotmail.com bangu00 166 Reputation points
2022-04-21T22:58:16.793+00:00

Hello,

i have sql servers with failover cluster on win 2016.
and nodes joined to ad(a.com).
i'm planning to move the nodes to new ad(b.com).
is there easy way?
i think follow steps.

  1. backup database and shutdown db
  2. destroy cluster
  3. rejoin new domain
  4. create cluster
  5. create role with sql server and msdtc
  6. service start
  7. restore database
  8. test failover
    could you please is it correct? anybody confirm me.

Have a nice day. in korea, groomy today. :-(

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
493 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
958 questions
Microsoft Entra

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,086 Reputation points Microsoft Vendor
    2022-04-22T05:27:36+00:00

    Hi @hotmail.com bangu00 ,

    Suggest you to read MS blog Migrating SQL Server to New domain and the third blog SQL SERVER – How to Move SQL Server Cluster to Different Domain to get detail information.

    Hope these blogs could help you.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    1 person found this answer helpful.
    0 comments
  2. hotmail.com bangu00 166 Reputation points
    2022-05-06T02:07:03.153+00:00

    Hello,

    I'm sorry for the late reply.
    Cathyji-msft's reply didn't really help me much.
    I don't think the link you gave me is the answer to my procedure.

    thank you.

    0 comments