How to cancel NOT STARTED subscription re-initialization? RRS feed

  • Question

  • Hello,

    I came early morning today to find that a replication stopped replicating because someone clicked to "Reinitialize Subscription".

    I don't know, but maybe we have a bit of luck that the initialization process did not start yet, and stuck on the status of "The initial snapshot for publication 'XYZ' is not yet available."

    Reinitializing that specific replication implies a lotof hectic work; so my first question is: How to cancel that NOT YET STARTED reinitialization process and resume the replication as nothing happened? second, how to find who did this?

    Note that I have "Microsoft SQL Server 2014 (SP2-GDR) (KB3194714) - 12.0.5203.0 (X64)   Sep 23 2016 18:13:56   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor) "  as the publisher, and "Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64)   Mar 19 2015 12:32:14   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) " as the subscriber.

    • Edited by Butmah Monday, May 8, 2017 6:43 AM
    Monday, May 8, 2017 6:11 AM

All replies

  • The only way to do this is to restore the replicated databases and the distribution database to a previous point in time. There is no way to find out who did this without having auditing in place prior to the reinitialization.
    • Proposed as answer by Tom Phillips Monday, May 8, 2017 7:55 PM
    Monday, May 8, 2017 5:42 PM