Merge Replication Failing With Error 'The scheme script could not be propogated to subscriber'
Posted on 2009-02-09
Ok, I've had merge replication set up for a long time on my two SQL 2000 servers. The only thing I changed was I added a Diagram on the primary database (DB01). Ever since I did that, my replication fails when I try to push the subscription with this error:
'The schema script \\servername\MSSQL\ReplData\unc\servername_dbName_dbName_Publication\20090209210207\tblNotes)132.dri could not be propagated to the subscriber.'
I'm at a complete loss as to what this error means. I've tried restoring the database from DB01 onto DB02 and still no luck. I've even tried deleting the database from DB02 and creating a new one when pushing the subscription.
Any help? Ideas?