SQL Merge Replication Problem

Posted on 2012-08-15
Last Modified: 2013-02-05
Hi All,

So I had a problem with my subscriber SQL server and had to restart the server.

Replication came back up fine afterwards and is working absolutely fine... HOWEVER...

I have checked a few count(*) on a number of tables and found there to be some rows missing at either end that were inserted around the time of the crash....

For example table tbl_asn has 402 rows at the Publisher but only 400 at the subscriber... and the time they were inserted was at the crash point.

My plan is to delete the records at the publisher manually and then recreate them again at the publisher.. given rep is working fine they should then replicate...?

Will this cause replication to fail when it tries to replicate the delete to the subscriber but not find a record??

SQL 2008 running on windows Server 2008.


Question by:gardmanIT
    1 Comment
    LVL 75

    Accepted Solution

    If the snapshot for the Publisher is correct all you have to do is Reinitialize the Subscription.  If that is not the case than you can generate a new snapshot before Reinitializing all Subscriptions.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now