Create distributed availability group on failover cluster instances

%3CLINGO-SUB%20id%3D%22lingo-sub-1165097%22%20slang%3D%22en-US%22%3ECreate%20distributed%20availability%20group%20on%20failover%20cluster%20instances%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1165097%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20know%20from%20documentation%20that%20we%20can%20add%20two%20separate%20SQL%20Failover%20Clusters%20in%20a%20distributed%20SQL%20AlwaysOn%20Availability%20group%2C%20my%20questions%20are%20as%20follows%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EDo%20we%20need%20to%20change%20all%20SQL%20FCI%20DBs%20recovery%20mode%20to%20Full%20as%20normal%20SQL%20AlwaysOn%20Availability%20Group%3F%3C%2FLI%3E%0A%3CLI%3EIs%20there%20any%20specific%20requirements%20or%20considerations%20other%20than%20Single%20AD%20Domain%20for%20both%20SQL%20FCI%2C%20and%20open%20only%20SQL%20Instances%20Ports%2C%20and%205022%3F%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3ERegards%2C%3C%2FP%3E%0A%3CP%3EMaged%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Hi,

 

I know from documentation that we can add two separate SQL Failover Clusters in a distributed SQL AlwaysOn Availability group, my questions are as follows:

  • Do we need to change all SQL FCI DBs recovery mode to Full as normal SQL AlwaysOn Availability Group?
  • Is there any specific requirements or considerations other than Single AD Domain for both SQL FCI, and open only SQL Instances Ports, and 5022?

Regards,

Maged

0 Replies