Replication Status :10% (forever)
Created: 09 Jan 2008 • Updated: 21 May 2010 | 5 comments
Have two servers that are supposed to be replicating hourly, but status of one replication partner has shown status of "Downloading 10%" for several days. The servers were originally set to replicate client packages (not a great idea through an Internet VPN), but that has been turned off.
The database seems to have replicated initially, and some changes have been passed between the servers since, but they are not identical (i.e., created a new group on one machine, and it never replicated to the other).
I know how to tell each Replication Partner to "Replicate Now", but is there a way to force a complete replication as in tell one server to copy the whole database to another (and over-write on the remote machine)?
What do we do once certain changes fail to replicate?