August 24, 2017 at 9:48 am
Hello Folks,
Is it possible to enable AlwaysOn secondary replica hosting on a different domain. Any option if the domains have trusted relationship?
If AlwaysOn not possible with different domains, any other solution like log shipping on top of existing AlwaysOn setup?
Please share your thoughts on this.
Environment details: Windows 2008 R2 /2012/2012 R2
SQL 2012 Enterprise
Many thanks!
August 24, 2017 at 10:00 am
I don't know all the "pros and cons", but it is possible with Windows Server 2016 and SQL Server 2016, as described in this article: https://blogs.technet.microsoft.com/dataplatforminsider/2015/12/15/enhanced-always-on-availability-groups-in-sql-server-2016/
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 24, 2017 at 10:03 am
Sorry, I got lost looking for the answer--it won't work on your present environment. Windows Server 2016 is the first platform that allows the WSFC to span more than one AD Domain. So, you would have to upgrade your OS to WS 2016 and SQL Server to 2016 too. Prior to Windows Server 2016, all nodes (servers) had to be on the same AD Domain; the only separation was in subnet and vlan; still in the same domain.
Hope that helps.
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 24, 2017 at 10:10 am
SQL_Hacker - Thursday, August 24, 2017 10:03 AMSorry, I got lost looking for the answer--it won't work on your present environment. Windows Server 2016 is the first platform that allows the WSFC to span more than one AD Domain. So, you would have to upgrade your OS to WS 2016 and SQL Server to 2016 too. Prior to Windows Server 2016, all nodes (servers) had to be on the same AD Domain; the only separation was in subnet and vlan; still in the same domain.
Hope that helps.
Thanks Alan!
August 24, 2017 at 11:48 am
You can combine it with log shipping. Refer to this:
SQL Server AlwaysOn combined with Log Shipping (Automatic)
You can find different options for 2012 in this blog post:
An overview of High Availability and Disaster Recovery solutions available for SQL Server
Sue
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply