question

Anoop.p avatar image
Anoop.p asked

Unable to complete Log shipping failover due to CDC (SQL Server 2016)

Issue: We are unable to perform Log shipping failover to DR Server due to CDC. While taking Tail log backup of DC database It is giving Error like "Unable to perform the task as connection to database is active".

From further troubleshooting, we've found that this is due to CDC actively listening for the changes in the CDC enabled tables. After disabling CDC we are able to successfully complete failover.

Requirement: We cannot loose any of the CDC data as it is used for auditing. Can anyone advice on how to perform Log shipping failover without compromising the CDC data. We will have to enable the CDC in DR as well after the fail over.

Does anyone know a possible solution to this problem?

log-shippingsql-server-2016cdc
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.