Replication gets dropped automatically

  • I am not sure who or what is doing it but as soon as I setup a snapshot replication and leave it for a day then the other day I find the replication gets dropped completely and I have no clue what process is doing it. I checked agent jobs as well and I couldn't find anything in there that would cause this. I am totally clueless and need some help to figure this out.

    Thanks

    Regards,

    Feivel

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Have you checked the default trace to see if anything its being logged as to what is removing it?

    Cant fully remember if replication is logged to the default trace but would be a starter for 10 to try and pinpoint whats going on.

    Other than that your into setting up audits and traces and XE sessions etc to track down what is removing it.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply