Groups > microsoft.public.sqlserver.replication > #6

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

X-Received	by 2002:ae9:e854:: with SMTP id a81mr2934948qkg.396.1588970619141; Fri, 08 May 2020 13:43:39 -0700 (PDT)
X-Received	by 2002:a25:1946:: with SMTP id 67mr7865253ybz.396.1588970618905; Fri, 08 May 2020 13:43:38 -0700 (PDT)
Path	csiph.com!xmission!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups	microsoft.public.sqlserver.replication
Date	Fri, 8 May 2020 13:43:38 -0700 (PDT)
In-Reply-To	<1B405F90-D463-45C2-9668-287482F11679@microsoft.com>
Complaints-To	groups-abuse@google.com
Injection-Info	google-groups.googlegroups.com; posting-host=99.236.77.192; posting-account=nUhM0woAAAB3FX8xlMdxH7OIwVLssCza
NNTP-Posting-Host	99.236.77.192
References	<5574412A-1862-4C6F-A567-012A6BFC4C0B@microsoft.com> <DBC22E2D-028A-47B8-9A2B-629AD7D0A7CE@microsoft.com> <1B405F90-D463-45C2-9668-287482F11679@microsoft.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<5d3ef113-00e0-4e46-8a0a-0516512438fe@googlegroups.com> (permalink)
Subject	Re: How to run a snapshot when one or more tables belong to other
From	josejojan94@gmail.com
Injection-Date	Fri, 08 May 2020 20:43:39 +0000
Content-Type	text/plain; charset="UTF-8"
Content-Transfer-Encoding	quoted-printable
Lines	45
Xref	csiph.com microsoft.public.sqlserver.replication:6

Show key headers only | View raw

On Wednesday, September 16, 2009 at 7:09:02 PM UTC-4, José Luis wrote:
> This post was solved by our technical team. We found out that the error was 
> caused because the Merge System Tables of the suscriptors were corrupted. For 
> some reason that we do not know there was the information of previous 
> replications in the table. So when the replication occurred all that 
> information was brought to the main server which makes the publication with 
> those redundancy tables. The error message was according to what was 
> happening. Now it would help us to know if there is some way through 
> configuration that we could prevent that in the future. It looked like the 
> SQL wasn´t cleaning the system merge tables each time that we eliminated the 
> suscriptor.

Hi, Can you explain in detail. I am also having the same issue. Tried recreating the publisher and subscriber again n again , but encountering the same issue. It would be great if you can help me
> 
> 
> > 
> > 
> > "José Luis" wrote:
> > 
> > > 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 suscription 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.
> >

Back to microsoft.public.sqlserver.replication | Previous | Next | Find similar

Thread

Re: How to run a snapshot when one or more tables belong to other josejojan94@gmail.com - 2020-05-08 13:43 -0700

csiph-web