I am trying to break replication between two SQL 2000 databases. Can this be done while the databases are live? or do they need to be taken offline?
Sql-server – Breaking database replication
replicationsql-server-2000
Related Question
- PostgreSQL – Switching Replication Master in Cascading Replication Scenario
- Sql-server – How to Properly shutdown and disassemble SQL Database Replication
- MySQL – Database Replication with Geo-Distributed Servers
- Sql-server – Questions around migrating to a live replicated database from an existing log shipping database in SQL Server 2016 SP1
- Postgresql – Database replication from local Postgres to live
- Sql-server – Bulk DELETEs in publisher breaking SQL Server Replication in subscriber
Best Answer
Delete publications from the Local Publications folder in Microsoft SQL Server Management Studio.
To delete a publication
1.Connect to the Publisher in Management Studio, and then expand the server node.
2.Expand the Replication folder, and then expand the Local Publications folder.
3.Right-click the publication you want to delete, and then click Delete.