Expand All
The document is archived and information here might be outdated

Removing Replication

Updated: 14 April 2006

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.

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).

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.

© 2016 Microsoft