August 20, 2009 at 11:13 am
Hello,
Two databases on two replicating servers have become out-of-sync. Most of the differences are in the msrepl_tran_version field. I was planning on using a TableDiff query to synchronize these fields across the databases, but I can't simply run the query, and there are many differences between the databases, so I'd rather not have to do that.
One thing I tried is to backup one database, bring it over to the other server, and try to equate the msrepl_tran_version field for all rows in the table. When I ran the TableDiff query after this, it did not show a reduced number of differences. Is it possible that this is because replication is up? Does anyone have any advice on how to efficiently synchronize these databases? Thanks.
August 20, 2009 at 11:25 am
Have you checked replication monitor to see what the status is on the last x distribution jobs?
~BOT
Craig Outcalt
August 20, 2009 at 11:51 am
No. Do you know how to do this from SQL 2008? I'm not familiar with the interface for the RM in that version, and that's what's on the servers.
August 20, 2009 at 12:24 pm
http://msdn.microsoft.com/en-us/library/ms151230.aspx
See the section titled: Viewing Information and Performing Tasks Related to Subscriptions
You're looking for 'distributor to subscriber history'.
~BOT
Craig Outcalt
August 20, 2009 at 2:30 pm
Thanks for the link. I'll take a look at it, and see if I can make sense of what happened.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply