February 21, 2009 at 5:16 am
I have got the follwing message while trying to synchronization. the messgae is 'The merge process could not initialize the subscription. The index entry for row ID was not found in index ID 2, of table 1511676433, in database 'ERP'.' Please I need a solution immediately. Please help me.
Fazle Rabbee
February 21, 2009 at 12:25 pm
data is not in sync between publisher and subscriber, please sync the data.
Rajesh Kasturi
February 21, 2009 at 12:35 pm
Sounds like you have data corruption. Please run the following in the database 'ERP'
DBCC CHECKDB ('ERP') WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have any idea when this started?
Do you have any backups of this database?
What version of SQL? (SELECT @@version)
Read through this - http://www.sqlservercentral.com/articles/65804/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 21, 2009 at 12:41 pm
Hppefully re-attempting synchronization did work for you. If not, you may want to look into the tablediff command line utility to compare the table at the Publisher and Subscriber.
ken
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply