question

Bill Goetschius avatar image
Bill Goetschius asked

How can we have Data Capture automatically Failover with AlwaysOn?

We are implementing Data Capture with our AlwaysOn environment SQL 2014 CU4. When an automatic Failover occurred Data Capture did not automatically failover. Even though the SQL Agent Data Capture jobs were on the Secondary Node they did not automatically start. To fix the issue I set the SQL Agent Data Capture job to run every 5 minutes and check to see if the Server Is Primary. If it is primary it executes the sys.sp_MScdc_capture_job. Is there a better way to make Data Capture failover automatically with AlwaysOn?
alwayson
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.