up vote 0 down vote favorite
share [g+] share [fb]

I'm trying to create merge replication database with SQL Server 2005 (Server) and SQL Server 2005 Express (Subscriber)

When I set replication between them, some time they can replicated but sometime not. I'm trying to using various to find pattern of error but not thing found.

  • Replicate only 1 table = work
  • Replicate 5 tables = sometime work but sometime not.
  • Replicate 10 tables = sometime work but sometime not.
  • Replicate 20 tables = always not work.
  • Get back to 1 table again, not work.

Each table in my database has about 1,000 rows, 50 columns, data is generated by tool.

I want to know how can I solving this problem?

Update Error message

The job failed. The Job was invoked by User sa. The last step to run was step 3 (Detect nonlogged agent shutdown.). The job was requested to start at step 1 (Merge Agent startup message.).

Update 2

Physical layout of this POC is Server is PC, Subscriber is Notebook. Connection between them is LAN.

link|improve this question
50% accept rate
'does not work' means what exactly? Any Error message or problem description you care to share so that someone can actually help you? – Remus Rusanu Aug 6 '10 at 16:10
Error message seem not help, I've added it to question though. – Ekkapop Aug 6 '10 at 16:46
What's the physical layout? The problem seems to be getting worse as the amount of data replicated goes up; are the servers on opposite sides of a low-reliability link? – Adrien Aug 6 '10 at 17:13
I doubt this problem come from performance of PC (use as server) or not, because sometime it can replicate but after trying to do replication for many times (about 10 or so) it always slow down or even restart itself. – Ekkapop Aug 7 '10 at 16:24
Can you add the actual replication error, not the agent error? Eg. the error saved in MSrepl_errors msdn.microsoft.com/en-us/library/ms188765.aspx, or the error displayed in the Replication Monitor subscription detail views. – Remus Rusanu Aug 8 '10 at 16:39
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.