BUG: No Mechanism for Cleaning Up Merge System Tables

ID: Q248623

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 56830 (SQLBUG_70)

SYMPTOMS

SQL Server 7.0 does not provide a way to clean up the contents of the MSmerge_contents and MSmerge_tombstone Merge Replication system tables. Since these tables keep track of inserts, updates, and deletes within the publications in a database, they could potentially cause storage problems.

CAUSE

Merge replication was designed to behave this way. Because this behavior has impacted performance for some customers, Microsoft is developing an easier method for cleaning up the MSmerge_contents and MSmerge_tombstone tables.

WORKAROUND

To clean up the Merge system tables, the database should be unpublished and republished. The Merge system tables should not be modified manually.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: merge replication system table

Keywords : SSrvRep kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug