November 15, 2011 at 8:20 am
I want to carry the database to another disk formation to speed up I/O. But the problem is before removing the replication publisher's db do not allow me to do it and because of removing the replication and resetting it cause a big problem, first I want to test it on my computer instead of live server.
But the problem is when subscriber have the database and datas on it, I am getting Foreign key errors:
"The schema script could not be propagated to the subscriber. (Source: Merge Replication Provider (Agent); Error number: -2147201001)
Could not drop object 'dbo.x' because it is referenced by a FOREIGN KEY constraint."
Because of there will be database and datas on the subscriber I don't want it to drop tables because synchronization may take too much time.
What may I do to avoid this error or what may I do to reject dropping the tables.
November 15, 2011 at 8:26 am
I am not sure if this will work but you can try deleting the constraint manually and adding it after the syncronization is complete
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply