"Paul Kleynhans" <pkleynhans@telkomsa.net> wrote in message
news:uxLwCv2zDHA.1688@TK2MSFTNGP10.phx.gbl...
> 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.
>
>

Paul Kleynhans wrote:
> *Hi
> I have been running Merge Replication with SQL200 Sp3a successfull
> for over
> 6 months now. We currently have 15 sites replicating to a centra
> server
> with an average of 5000 transactions per site per day.
>
> Everything was going fine up until 3 days ago, when I got th
> following
> error on some of my sites:
>
> -2147200940: The Publisher has been restored from a backup whos
> schema
> change version is different from the Subscriber. Rerun the Snapsho
> Agent
> and reinitialize the subscription.
>
> I followed the instruction in the error message and reinitialise
> the
> affected client sites after creating a new snapshot, but the erro
> changed
> to the following error:
>
> -2147201001: The schema script 'exec sp_repldropcolum
> '[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 o
> column
> 'ProductDescription'.
> 4922: ALTER TABLE DROP COLUMN ProductDescription failed because on
> or more
> objects access this column.
>
>
> My initial thoughts would've been that a column change I did in th
> database
> would cause this, but the last changes made to the database structur
> was
> done more than 30 days ago, and all sites have been replicating fin
> since
> then. Currently my biggest concern is that the clients are stil
> generating
> data and that that data may be lost when recovering from thi
> problem. The
> interesting news is that the correct schema is resident at th
> clients that
> are giving me this problem, so I have no idea why this error i
> occuring.
>
> Any help would be appreciated.