sql server replication: I have a one publisher and 5 subscribers at a distant locations, of these 4
locations are working fine, but one of my database is not getting
synchronized even though the setting are the same for the database.

This message was noticed after my system was infected with spida worm.
When the system was infected with spida i scanned the computer and
i have reinitialized the subscription database and everything was working
fine.

But sooner i had found that the synchronization was not getting done
between the effected subscriber and publisher and the tempdb database files
are also increasing a lot.

The error message i see on the replication monitor is
"The merge process could not retrieve generation information at the
subscriber" and the
last command : {call sp_MSenumgenerations(640100,?,1)}

Plz advice me i am running on a production database.

--

The problem is due to the huge increase in the system tables
Msmerge_genhistory, Msmerge_contents,Msmerge_tombstone.
Removing the history from this system tables would solve this problem

--