SQL Server 2014 AOAG + Replication?
Clash Royale CLAN TAG#URR8PPP
I have an existing SQL Server (2014) setup using Always On Availability Groups. All the documentation says I should not try to install replication (aka distributor role) on any of the servers participating in the Always On Availability Groups.
Why does the documentation warn against doing that, will it break Always On? Does Always On prevent replication from working? Or is there some other reason?
sql-server sql-server-2014 availability-groups transactional-replication
edited Feb 25 at 15:51
MDCCL
6,85331745
asked Feb 25 at 15:47
davidpricedevdavidpricedev
1112
add a comment |
I have an existing SQL Server (2014) setup using Always On Availability Groups. All the documentation says I should not try to install replication (aka distributor role) on any of the servers participating in the Always On Availability Groups.
Why does the documentation warn against doing that, will it break Always On? Does Always On prevent replication from working? Or is there some other reason?
sql-server sql-server-2014 availability-groups transactional-replication
edited Feb 25 at 15:51
MDCCL
6,85331745
asked Feb 25 at 15:47
davidpricedevdavidpricedev
1112
add a comment |
I have an existing SQL Server (2014) setup using Always On Availability Groups. All the documentation says I should not try to install replication (aka distributor role) on any of the servers participating in the Always On Availability Groups.
Why does the documentation warn against doing that, will it break Always On? Does Always On prevent replication from working? Or is there some other reason?
sql-server sql-server-2014 availability-groups transactional-replication
edited Feb 25 at 15:51
MDCCL
6,85331745
asked Feb 25 at 15:47
davidpricedevdavidpricedev
1112
I have an existing SQL Server (2014) setup using Always On Availability Groups. All the documentation says I should not try to install replication (aka distributor role) on any of the servers participating in the Always On Availability Groups.
Why does the documentation warn against doing that, will it break Always On? Does Always On prevent replication from working? Or is there some other reason?
sql-server sql-server-2014 availability-groups transactional-replication
sql-server sql-server-2014 availability-groups transactional-replication
edited Feb 25 at 15:51
MDCCL
6,85331745
asked Feb 25 at 15:47
davidpricedevdavidpricedev
1112
edited Feb 25 at 15:51
MDCCL
6,85331745
asked Feb 25 at 15:47
davidpricedevdavidpricedev
1112
edited Feb 25 at 15:51
MDCCL
6,85331745
edited Feb 25 at 15:51
MDCCL
6,85331745
edited Feb 25 at 15:51
MDCCL
6,85331745
6,85331745
asked Feb 25 at 15:47
davidpricedevdavidpricedev
1112
asked Feb 25 at 15:47
davidpricedevdavidpricedev
1112
asked Feb 25 at 15:47
davidpricedevdavidpricedev
1112
1112
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
IN SQL Server 2014 and earlier, the replication jobs will not continue to work after failover if you put the Distribution Database in an AG.
If you upgrade to SQL Server 2016 or 2017, this becomes a supported configuration:
SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3 introduces support for
replication distribution database in an AG
Set up replication distribution database in Always On availability group
answered Feb 25 at 15:56
David Browne - MicrosoftDavid Browne - Microsoft
12.1k729
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230676%2fsql-server-2014-aoag-replication%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
IN SQL Server 2014 and earlier, the replication jobs will not continue to work after failover if you put the Distribution Database in an AG.
If you upgrade to SQL Server 2016 or 2017, this becomes a supported configuration:
SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3 introduces support for
replication distribution database in an AG
Set up replication distribution database in Always On availability group
answered Feb 25 at 15:56
David Browne - MicrosoftDavid Browne - Microsoft
12.1k729
add a comment |
IN SQL Server 2014 and earlier, the replication jobs will not continue to work after failover if you put the Distribution Database in an AG.
If you upgrade to SQL Server 2016 or 2017, this becomes a supported configuration:
SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3 introduces support for
replication distribution database in an AG
Set up replication distribution database in Always On availability group
answered Feb 25 at 15:56
David Browne - MicrosoftDavid Browne - Microsoft
12.1k729
add a comment |
IN SQL Server 2014 and earlier, the replication jobs will not continue to work after failover if you put the Distribution Database in an AG.
If you upgrade to SQL Server 2016 or 2017, this becomes a supported configuration:
SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3 introduces support for
replication distribution database in an AG
Set up replication distribution database in Always On availability group
answered Feb 25 at 15:56
David Browne - MicrosoftDavid Browne - Microsoft
12.1k729
IN SQL Server 2014 and earlier, the replication jobs will not continue to work after failover if you put the Distribution Database in an AG.
If you upgrade to SQL Server 2016 or 2017, this becomes a supported configuration:
SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3 introduces support for
replication distribution database in an AG
Set up replication distribution database in Always On availability group
answered Feb 25 at 15:56
David Browne - MicrosoftDavid Browne - Microsoft
12.1k729
answered Feb 25 at 15:56
David Browne - MicrosoftDavid Browne - Microsoft
12.1k729
answered Feb 25 at 15:56
David Browne - MicrosoftDavid Browne - Microsoft
12.1k729
answered Feb 25 at 15:56
David Browne - MicrosoftDavid Browne - Microsoft
12.1k729
12.1k729
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230676%2fsql-server-2014-aoag-replication%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
