I have an issue with one of my subscribers getting the dreaded "The
Publisher has been restored from a backup whose schema change version is
different from the Subscriber." error on one of the publications. I have a
total of 6 publications and the error only occurs one of them. After
receiving the error I removed all the subscriptions and recreated them with
scripts that I've been using on all my subscribers. The same occur still
occurs on the same subscription. I've run out of ideas on how to solve
the issue.
Any help would be appreciated!
Thanks
Tina
Tina,
this error message is one of the things which have been solved in sp3, if
you are using merge replication with @.enabled_for_internet set to true (see
http://support.microsoft.com/default...ticle%3D319961).
HTH,
Paul Ibison
|||Hi Paul,
Unfortunately I have that parameter set to false and I'm on SP3.
Any other ideas?
Thanks
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23yK$AcWLEHA.988@.TK2MSFTNGP11.phx.gbl...
> Tina,
> this error message is one of the things which have been solved in sp3, if
> you are using merge replication with @.enabled_for_internet set to true
(see
>
http://support.microsoft.com/default...ticle%3D319961).
> HTH,
> Paul Ibison
>
Showing posts with label thepublisher. Show all posts
Showing posts with label thepublisher. Show all posts
Monday, March 12, 2012
Wednesday, March 7, 2012
Publisher, Distribution, Subscriber all on one SQL Server?
Should this work? In production we have one server acting as the
publisher/distributer, and then another as the subscriber.
In the test environment, I'd like to have all of this on the same
server. Will this work? I've run into what I hope is a minor gotcha
(running the drop replication scripts created by enterprise manager
doesn't work, exec sp_dropsubscription returns "The remote server is
not defined as a subscription server").
thanks for any hints.
Sylvia
Hey. I've the same setup at my company for testing. It works fine. I have 2
instances of SQL, one acting as a subscriber and the other acting as a
publisher/distributor for transactional and merge replication. I've 3
publications so far.
For your structure, how is it defined? On your publication, have you defined
the same server as a publisher as well as a subcriber?
|||I even do pull subscriptions using FTP on a single server.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sylvia" <sylvia@.vasilik.com> wrote in message
news:1130800544.680463.133070@.z14g2000cwz.googlegr oups.com...
> Should this work? In production we have one server acting as the
> publisher/distributer, and then another as the subscriber.
> In the test environment, I'd like to have all of this on the same
> server. Will this work? I've run into what I hope is a minor gotcha
> (running the drop replication scripts created by enterprise manager
> doesn't work, exec sp_dropsubscription returns "The remote server is
> not defined as a subscription server").
> thanks for any hints.
> Sylvia
>
publisher/distributer, and then another as the subscriber.
In the test environment, I'd like to have all of this on the same
server. Will this work? I've run into what I hope is a minor gotcha
(running the drop replication scripts created by enterprise manager
doesn't work, exec sp_dropsubscription returns "The remote server is
not defined as a subscription server").
thanks for any hints.
Sylvia
Hey. I've the same setup at my company for testing. It works fine. I have 2
instances of SQL, one acting as a subscriber and the other acting as a
publisher/distributor for transactional and merge replication. I've 3
publications so far.
For your structure, how is it defined? On your publication, have you defined
the same server as a publisher as well as a subcriber?
|||I even do pull subscriptions using FTP on a single server.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sylvia" <sylvia@.vasilik.com> wrote in message
news:1130800544.680463.133070@.z14g2000cwz.googlegr oups.com...
> Should this work? In production we have one server acting as the
> publisher/distributer, and then another as the subscriber.
> In the test environment, I'd like to have all of this on the same
> server. Will this work? I've run into what I hope is a minor gotcha
> (running the drop replication scripts created by enterprise manager
> doesn't work, exec sp_dropsubscription returns "The remote server is
> not defined as a subscription server").
> thanks for any hints.
> Sylvia
>
Subscribe to:
Posts (Atom)