How to stop Replication

• Arun Benjamin

  SSCommitted

  Points: 1614

  More actions

  August 28, 2008 at 4:45 am

  #96387

  Hi all,

  I need to migrate the data and log file of the Distribution database in an SQL 7 instance. I cannot detach it because it is in use by replication. Can someone let me if it is possible to stop the distributor without deleting the publishers.

  Regards

  Arun

• KDASQL

  Ten Centuries

  Points: 1103

  More actions

  August 29, 2008 at 5:55 pm

  #865326

  Not in SQL 7. You will have to delete the publication and re-create it again.