Post reply

Deleted Merge Replication

  • November 7, 2005 at 11:20 am

    #169581

    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 8, 2005 at 10:56 am

    #602849

    five cross-posts?  you should be banned if you ever do this again.  okay, perhaps not banned... just shunned

    Cheers,

    david russell

  • November 9, 2005 at 12:56 pm

    #603104

    I don't have exact solution to your problem at this point of time,

    will probably come out solution but for while can suggest you to refer

    http://www.replicationanswers.com/Merge.asp 

    or articles by Alexender chigrik in database Journal.

    one additional note

     we are all living in free world and this platform allows everyone to find help for their tech. requirements but there are few who just do not understand that and finds way to look smart otherwise.

    -- It is important to look smart but it is more important to be good.

      

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • November 9, 2005 at 1:58 pm

    #603123

    Thanks Sameer.  I had a job I believe that runs on Saturday night and that was what was causing the replication to reappear.

     

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

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