SQL alwayson disaster recovery

%3CLINGO-SUB%20id%3D%22lingo-sub-1572131%22%20slang%3D%22en-US%22%3ESQL%20alwayson%20disaster%20recovery%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572131%22%20slang%3D%22en-US%22%3EHello%3CBR%20%2F%3ENeed%20advise%20on%20below%3A%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%202%20node%20alwayson%20AG%20on%20Primary%20Sync%20mode%20in%20the%20current%20configuration%20and%20fsw%20is%20in%20Primary%20DC%20only%3CBR%20%2F%3EActually%20during%20Switchover%20the%20entire%20DC%202%20node%20and%20fsw%20will%20be%20down%3CBR%20%2F%3EWhich%20DR%20configuration%20should%20I%20opt%20in%20this%20situation%20for%20little%20manual%20steps%20and%20DR%20can%20come%20up%20without%20much%20issues%3A%3CBR%20%2F%3E2%20Node%20Async%20in%20DR%3CBR%20%2F%3E1%20Node%20Async%20in%20DR%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20using%20SQL%202012%20Enterprise%2C%20Windows2012%20OS%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1577748%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20alwayson%20disaster%20recovery%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1577748%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F752116%22%20target%3D%22_blank%22%3E%40Mukki970%3C%2FA%3E%3C%2FP%3E%3CP%3ESorry%20to%20disappoint%20you%20but%20this%20is%20the%20Microsoft%20Learn%20community%20and%20is%20not%20exactly%20specialized%20on%20your%20topic%2Fquestion.%20Although%20one%20or%20the%20other%20MCT%20specialized%20in%20this%20technology%20could%20be%20visiting%20this%20community%20I%20have%20the%20feeling%20that%20your%20question%20should%20be%20posted%20in%20the%20respective%20community.%3CBR%20%2F%3EThank%20you%20for%20your%20understanding.%20Here%20is%20the%20link%20to%20the%20community%3A%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsql-server%2Fct-p%2FSQL-Server%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsql-server%2Fct-p%2FSQL-Server%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ECheers%3CBR%20%2F%3E%3CBR%20%2F%3ERolf%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%23MCT%20%23LearnWithRolf%20%23TheCloud42%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hello
Need advise on below:

I have 2 node alwayson AG on Primary Sync mode in the current configuration and fsw is in Primary DC only
Actually during Switchover the entire DC 2 node and fsw will be down
Which DR configuration should I opt in this situation for little manual steps and DR can come up without much issues:
2 Node Async in DR
1 Node Async in DR

I am using SQL 2012 Enterprise, Windows2012 OS
1 Reply

Hello @Mukki970

Sorry to disappoint you but this is the Microsoft Learn community and is not exactly specialized on your topic/question. Although one or the other MCT specialized in this technology could be visiting this community I have the feeling that your question should be posted in the respective community.
Thank you for your understanding. Here is the link to the community:


https://techcommunity.microsoft.com/t5/sql-server/ct-p/SQL-Server


Cheers
Rolf
#MCT #LearnWithRolf #TheCloud42