Delen via


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

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.

See Also

Other Resources

Implementing Replication

Help and Information

Getting SQL Server 2005 Assistance