SQL Server Performance

NO DATA @ the Subscriber..

Discussion in 'SQL Server 2005 Replication' started by sql_jr, Jul 26, 2007.

  1. sql_jr New Member

    I have a merge replication model setup with no errors, yet the data is not EVEN on the subscriber at all, and not in synch? What gives? Any ideas? TIA

    Edit: I see some errors.
    First, it says it cannot open the database, which was part of an OLD setup, but the monitor still sees it. I'm actually pointing to another database - maybe there's a conflict? How can I clean up an old publication? Thx!
  2. MohammedU New Member

    Check procedure sp_droppublication... check BOL for syntax...

    http://msdn2.microsoft.com/en-us/library/ms188363.aspx


    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. sql_jr New Member

    Any ideas why data @ the subscriber is deleting data during synchronization??
    thx
  4. MohammedU New Member

    It depends on the how you confiugred your snapshot for the publication...
    There are multiple ways...
    1. drop and recreate table and copy the data..
    2. Delete matching rows and copy the data...
    3. delete all rows and copy the data without drop and recreating the table.
    etc...

Share This Page