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… http://msdn2.microsoft.com/en-us/library/ms188363.aspx
Microsoft SQL Server MVP
SQL-Server-Performance.com 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.