SQL Server Performance Forum – Threads Archive

Snapshot Never Ends? – Merge….

Hi, I’ve set up merge replication, and generated the snapshot. Its been running for 18+ hours, and looking at the Monitor, it looks like it’s going in a continous circle. The messages change from ‘Preparing Table X for merge replication’ and ‘Applied script x.cgf’ and goes thru all the objects, and applying snapshot. However, the subscriber apparently doesn’t appear to have ANY data in it. I restored a clean copy to both sides, with data, but the sync seemed to delete the data. Data is on publisher,not subsc. There are no errors on the monitor, but in this continuous state. Any ideas? Please help? Where should I look. This is the 2nd time this occurred.

Try to enable logging and run the sql trace also to see what is going on… How to enable replication agents for logging to output files in SQL Servehttp://support.microsoft.com/kb/312292
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

HELP! 1st it seems there is absolutely NO synchronization going on and no errors being generated.
2nd, for SQL2005, what exactly are the steps to turn on logging. PLEASE ADVISE!!!

Article I mentioned works for both sql 2000 and 2005. MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

http://dineshasanka.spaces.live.com/blog/cns!22A79FCE82651673!289.entry

]]>