Dan

My feedback

  1. 101 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  12 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Dan commented  · 

    Same issue. Last week I applied SQL 2016 SP2 to both nodes of an AG. I have a database that was once performing trans. repl. and this has been removed. As a result we have 2x CDC SQL jobs (capture & cleanup). The capture job was showing this error message:

    Executed as user: domain\user. Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction. [SQLSTATE 42000] (Error 3933)

    The other major consequence was the transaction log had grown considerably and could not be shrunk. The affected DB was showing [REPLICATION] in the log_reuse_wait_desc as per this article by Paul Randal:
    https://www.sqlskills.com/blogs/paul/replication-preventing-log-reuse-but-no-replication-configured/

    I removed option 'per database DTC support', was then able to run this command:
    EXEC sys.sp_removedbreplication 'DBName';

    The capture job is now working as expected & I was able to bring the log file back to normal size.

    FYI - I cannot enable the option [per database DTC support] the capture job immediately starts to output the same error as shown above

    Dan supported this idea  · 

Feedback and Knowledge Base