May 7, 2009 at 8:19 am
Hello all,
I have an issue with replication and a tool I use to compare data if replication fails! Here is the situation and then my question will follow. We have replication set up across 3 servers! If on one of the servers replication fails, I have to restart synchronization and then run Redgate's SQL Data Compare! After the compare is complete I scroll down to see which tables are different across the server concerning missing records from one to the other. Lets say on Server A one table shows 50 records that are different from Server B. Then I have to manually go through each record and see which server has the latest modified date and synchronize to make the servers match. So lets say Server B has the latest modified date on 30 records so I would have to synchronize to make A like B and then turn around for the other 20 records and make B like A! As you can tell, this process is a little overwhelming when one table might have over 1000 records that are different! So I am wondering 1.) if there is a way to automate replication where when it fails it automatically resynchronizes? and 2.) If there was a way to automate the data compare to compare the tables across two servers and synchronize according to the latest modified date?
If anyone has any suggestions or solutions, it is greatly appreciated!
Thanks
Adam Massey
Database Administrator II
May 8, 2009 at 7:58 am
First, what kind of replication are you using ?
Second what do you mean by "replication fails" ?
* Noel
May 8, 2009 at 8:31 am
Transactional Replication is the type of Replication that I am using and it is in SQL Server 2000. What I mean by replication fails, it stops replicating to the other 2 servers! Then I right click on the server that it failed on and click Start Synchronizing. I refresh the Replication Monitor and it turns back green! Then I run SQL Data Compare to compare the two servers and check for different records across the two servers. Hope this answers your question!
May 8, 2009 at 9:07 am
It fail because of "data" errors or because "connectivity" errors ?
Can you post a sample Error Message?
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply