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?