NO DATA @ the Subscriber.. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

NO DATA @ the Subscriber..

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!
Check procedure sp_droppublication… check BOL for syntax…
Microsoft SQL Server MVP
Moderator All postings are provided “AS IS” with no warranties for accuracy.

Any ideas why data @ the subscriber is deleting data during synchronization??

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.