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 |
|
ome001
Starting Member
4 Posts |
 Posted - 2009-09-15 : 04:42:43
|
| Hi to the forum.I am doing a merge replication within 4 servers. I have a couple tables that run into differerent publications. In one of ther servers I got the following error: "The subscription could not be initialized using an initial snapshot because one or more tables in the subscription belong to another publication, and therefore cannot be dropped" (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200976). The others worked fine. I searched through the web looking for some advice but mostly are related to SQL Server 2000 and I have all servers on SQL Server 2005 with service pack 2.Thanks in advance, José |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2009-11-04 : 06:35:38
|
| looks like while initilizing, its trying to drop the subscriber table & recreate. This is not possible since, the subscriber table already belongs to another replication. Check if another publication exists on those tables. What puplication type you are using ?Thanks,Krishnawww.SQLServer.in |
 |
|
|
|
|
|
How to run a snapshot when one or more tables belo