Export (0) Print
Expand All

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.

ms152757.note(en-US,SQL.90).gifNote:
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).

ms152757.note(en-US,SQL.90).gifNote:
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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft