October 19, 2006 at 2:37 pm
Are there any issues with having multiple subscriptions to one publication ? I have a SQL 2000 publisher, and a SQL 2000 subscriber and a SQL 2005 subscriber, I'm havibg problems with one of the 2005 subscriptions, and wonder if I should set up a separate 2000 publication for the 2005 subscription.
October 19, 2006 at 6:33 pm
It is not unusual to have several subscriptions to one publication, even with mixing 2000 with 2005 versions of SQL Server. My setup currently has a number of subscribers on 2000 and one on 2005 that uses table partitioning, and I have had no issues so far. What kind of problems are you having?
October 20, 2006 at 12:02 pm
Unless there is a work around that I am not aware of, replication is not supported between SQL 2000 and 2005 where 2000 is the publisher. In order to replicate between them, the higher version has to be the publisher. So, yes, you can have SQL 2000 subscribers to a SQL 2005 publisher, but nto the reverse.
October 20, 2006 at 12:23 pm
I've got 5 2000 publishers going to 5 2005 subscribers. I'm having trouble with 1 of the subscribers balancing the record counts to what i think they should be, and getting skiperrors that I don't quite understand. It seems that 2000 to 2005 works in general, but I've got strange results in one case that I'm trying to troubleshoot.
October 20, 2006 at 12:50 pm
My mistake. My statement only applies to merge replicationn. I didn't realize until now that the rules were different for transactional and snapshot replication.
October 24, 2006 at 6:47 pm
Have you tried to validate the subscribers to make sure that they have the same record count? If not then simply determine the missing record and add it to the subscribers. Currently, it looks like the distribution agent is configured to use the skip errors switch. This is fine, but you will still need to determine the cause - in this case a missing record!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply