One of our clients set up merged replication between two SQL Servers.
Replication occurs every ten minutes. A problem occurs when they capture
employee information through a web application affecting several tables that
the information in some of the tables "disappears". What would be the best
way for me to investigate what the problem could be?
It depends on how the info was added. If it is a bulk insert, or a fast load
from DTS, then the replication triggers won't fire by default, and the data
will be left on one side only. Is that what you're seeing? If it is instead
that data is successfully added then disappears, it might be that you have
compensating changes occurring
(http://support.microsoft.com/default.aspx?scid=kb;en-us;828637&Product=sql2k).
Cheers,
Paul
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment