SQL Server Performance

Cleanup MSMerge_Errorlineage

Discussion in 'Performance Tuning for SQL Server Replication' started by lucian.ctin, May 4, 2008.

  1. lucian.ctin New Member

    Hello,
    I need an oppinion about deleting data from MSMerge_Errorlineage. This table takes about 450 MB storage space.
    Does this operation affect the replication process?
    Thank you,
    Lucian CONSTANTIN
  2. MohammedU New Member

    Why you want to delete the data?
    The MSmerge_errorlineage table contains rows that have been deleted at the Subscriber, but whose delete is not propagated to the Publisher. This table is stored in the publication and subscription databases.

Share This Page