Replication

  • I really need to disable all replication on a particular server, but only temporarily. Where is this wonderful "disable replication" option, can u tel me plzzzzzz and tel me to enable replication

    wat actually process has to be done can u explain clearlyyyyyy in step by step method

    Thanks& Regards

    Ram-----

  • Stop the log reader agent and Snapshot agent. maybe if the changes get too stale you might have to reinitialize it.

    -Roy

  • Hi i noticed that snapshot agent is start postion is enabled and stop is disabled but how can we stop the snapshot agent,plz tel me ,i have noticed that logreader agent is enabled stop tab,it is ok to stop the agent,,,,,,,,then problem only with snapshot agent

    tel me steps wise plzzzzzzzzzzzzzzzzzzz

    plz reply me as soon as possible

    Thanks and regards

    ram

  • Open the replication monitor, click on the publication in the left window and go to the agents tab where you will find all the 3 agents. you can right click and stop all the 3 agents.

    the other option, go the sql server agent -> Jobs , identify the job that will be in similar name to the publication name and stop it.

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

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