locked
merge replication RRS feed

  • Question

  • ALL,

            i have merge replication setup on sql server 2008 with filtering and partiotion data.....i see some of records in msmerge_past_partition_mappings table  though tthe data belongs to same partition ..Any suggestions??

    Friday, May 13, 2011 7:09 PM

Answers

  •             very interesting... i dont understand y would be records going into msmerge_past_partition_mappings where BOL says it goes only row is out of partition..and also when row is deleted...but i am seeing same record in msmerge_past_partition_mappings and msmerge_current_partition_mappings tables

    We can learn from Sujoy Paul in Pro SQL Server 2008 Replication, in Table 14-2 Tables Affected by DML Operations in a Publication with Parameterized Filters, that an update DML operation that causes a row to be moved to another partition causes an entry to be made into both MSmerge_current_partition_mappings and MSmerge_past_partition_mappings.  This could explain why you're seeing the same record in both.

    Hope this helps.


    sqlrepl.com
    • Proposed as answer by Peja Tao Tuesday, May 17, 2011 2:58 AM
    • Marked as answer by Peja Tao Monday, May 23, 2011 2:18 AM
    Monday, May 16, 2011 5:44 AM

All replies

  • This is normal.
    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Friday, May 13, 2011 8:40 PM
    Answerer
  • Hilary,

                very interesting... i dont understand y would be records going into msmerge_past_partition_mappings where BOL says it goes only row is out of partition..and also when row is deleted...but i am seeing same record in msmerge_past_partition_mappings and msmerge_current_partition_mappings tables

    Saturday, May 14, 2011 4:42 PM
  •             very interesting... i dont understand y would be records going into msmerge_past_partition_mappings where BOL says it goes only row is out of partition..and also when row is deleted...but i am seeing same record in msmerge_past_partition_mappings and msmerge_current_partition_mappings tables

    We can learn from Sujoy Paul in Pro SQL Server 2008 Replication, in Table 14-2 Tables Affected by DML Operations in a Publication with Parameterized Filters, that an update DML operation that causes a row to be moved to another partition causes an entry to be made into both MSmerge_current_partition_mappings and MSmerge_past_partition_mappings.  This could explain why you're seeing the same record in both.

    Hope this helps.


    sqlrepl.com
    • Proposed as answer by Peja Tao Tuesday, May 17, 2011 2:58 AM
    • Marked as answer by Peja Tao Monday, May 23, 2011 2:18 AM
    Monday, May 16, 2011 5:44 AM