Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fcaglayan
Starting Member
1 Post |
 Posted - 2011-11-16 : 05:47:21
|
| 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. |
|
|
|
|
|
Merge Replication Foreign Key Error