Removing Replication
The actions required to remove replication from a database or server depend on the role that the database or server plays. The following links provide information about removing various replication components.
Note
If you are unable to remove a replication component using the method provided, execute the stored procedure sp_removedbreplication (Transact-SQL) on the appropriate database(s).
- Publication database
- SQL Server Management Studio: How to: Delete a Publication (SQL Server Management Studio)
- Replication Transact-SQL programming: How to: Delete a Publication (Replication Transact-SQL Programming)
- Replication Management Objects (RMO) programming: How to: Delete a Publication (RMO Programming)
- Subscription database
- SQL Server Management Studio: How to: Delete a Push Subscription (SQL Server Management Studio) and How to: Delete a Pull Subscription (SQL Server Management Studio)
- Replication Transact-SQL programming: How to: Delete a Push Subscription (Replication Transact-SQL Programming) and How to: Delete a Pull Subscription (Replication Transact-SQL Programming)
- RMO programming: How to: Delete a Push Subscription (RMO Programming) and How to: Delete a Pull Subscription (RMO Programming)
- Distribution database and Distributor configuration
- SQL Server Management Studio: How to: Disable Publishing and Distribution (SQL Server Management Studio)
- Replication Transact-SQL programming: How to: Disable Publishing and Distribution (Replication Transact-SQL Programming)
- RMO programming: How to: Disable Publishing and Distribution (RMO Programming)
Note
To disable publishing and distribution, all distribution and publication databases must be online. If any database snapshots exist for distribution or publication databases, they must be dropped before disabling publishing and distribution. A database snapshot is a read-only offline copy of a database and is not related to a replication snapshot. For more information, see Database Snapshots.