Any idea as to how SQL Server ensures that no data is lost during replication. In my project we have some across several instances where the SQL server indicates that the data has been replicated but it is not recieved at the other end. The network is not very reliable, in case the network link is lost during replication how does SQL ensure no data is lost. If you know the answers or have any documents please share the same.
Thanks,
Shalin Parmar
It depends on the replication type you deploy.
You need a consistent connection when you use Transactional Replication. However, you do not need a consistent connection with Merge replication. Only modifications are replicated with these two types of replication.
Your data loss may be because of some conflicts if you have more than one Subscriber in your replication frame. If so, there are conflict solutions to use with replication.
Ekrem ?nsoy
MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE
No comments:
Post a Comment