Post reply

Deleted Merge Replication

  • November 7, 2005 at 11:20 am

    #110744

    I had deleted a merge replciation running sp_removeddbreplication and also checking MS_Publications table ans MS_Snapshot_Agents table in the distribution database.  But for some reason the deleted merge replication reappears every Monday.  I remove it and it works for a week and reappears on Monday.  I know how to remove it temporarily by running sp_removeddbreplication and making sure no references to it exist in the MS_Publications and MS_Snapshot_Agents tables in the distribution database.

    Please advise on how to remove them permanently?  Want could be causing them to reapear every Monday?  Any inputs will be much appreciated as I am fairly new to replciation and being a SQL Server DBA.

    Thanks,

    Manisha

  • November 7, 2005 at 10:15 pm

    #602719

    Hi ,

     

    Check the jobs , might be possible there may be a job left undeleted.

    or Restart the sql services.

    HTH

    from

    Killer

  • November 8, 2005 at 10:51 am

    #602842

    you don't need to cross-post to get responses

    Cheers,

    david russell

  • November 8, 2005 at 12:39 pm

    #602867

    There is some job, process or someone that is rebuilding the publication, the job probably runs late Sunday night or early Monday morning.

    If this is the only publication on this server then you can disable this server as a distributer. the next time the job or process run to create the publication it will fail.

    Good luck.

     

    Don't count what you do, do what counts.

    SQL Draggon

Viewing 4 posts - 1 through 4 (of 4 total)

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