How to run a snapshot when one or more tables belong to other publication

• ome001

  SSC Veteran

  Points: 288

  More actions

  September 15, 2009 at 10:38 pm

  #226145

  Hi.

  Trying to start the snapshot 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).

  I could make the first server publication and replication with no problem.

  When I try to replicate with other suscriptor it is when I got this error.

  Regards, José

  P.S. Running SQL Server 2005 enterprise edition with SP2 on Windows 2003

  server. Merge replication.

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  September 22, 2009 at 7:54 am

  #1056760

  If you add the table as a different Publication, you should be able to snapshot it if I am not mistaken

  -Roy