Re: The Publisher has been restored from a backup whose schema change version is different from the Sub
From: kanu25 (kanu25.1armcb_at_mail.mcse.ms)
Date: 08/10/04
- Next message: LeeH: "Re: Queue Reader - remote procedure call failed"
- Previous message: Paul Ibison: "Re: restore the replication system"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 10 Aug 2004 01:01:25 -0500
How did you end up solving this issue and are your sites local or via
ADSL?
I am about to go through the same thing using MSDE2000 at the site as
publisher/distributors across ADSL internet to SQL2000 as subscriber at
head office. Know of any potential issues to look out for?
Paul Kleynhans wrote:
> *Hi
> I have been running Merge Replication with SQL200 Sp3a successfully
> for over
> 6 months now. We currently have 15 sites replicating to a central
> server
> with an average of 5000 transactions per site per day.
>
> Everything was going fine up until 3 days ago, when I got the
> following
> error on some of my sites:
>
> -2147200940: The Publisher has been restored from a backup whose
> schema
> change version is different from the Subscriber. Rerun the Snapshot
> Agent
> and reinitialize the subscription.
>
> I followed the instruction in the error message and reinitialised
> the
> affected client sites after creating a new snapshot, but the error
> changed
> to the following error:
>
> -2147201001: The schema script 'exec sp_repldropcolumn
> '[dbo].[c_products]',
> 'ProductDescription', 1' could not be propagated to the subscriber.
>
> The detail of the above error states the following:
>
> 27160: A column was added to or dropped from the replicated table.
> 5074: The object 'DF__c_product__Produ__7A3719BC' is dependent on
> column
> 'ProductDescription'.
> 4922: ALTER TABLE DROP COLUMN ProductDescription failed because one
> or more
> objects access this column.
>
>
> My initial thoughts would've been that a column change I did in the
> database
> would cause this, but the last changes made to the database structure
> was
> done more than 30 days ago, and all sites have been replicating fine
> since
> then. Currently my biggest concern is that the clients are still
> generating
> data and that that data may be lost when recovering from this
> problem. The
> interesting news is that the correct schema is resident at the
> clients that
> are giving me this problem, so I have no idea why this error is
> occuring.
>
> Any help would be appreciated. *
-- kanu25 ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message230134.html
- Next message: LeeH: "Re: Queue Reader - remote procedure call failed"
- Previous message: Paul Ibison: "Re: restore the replication system"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
