Upgrading Replication - Effects ?
Hi There
Ok i have a publisher, remote distributor and subscriber all SQL2000.
Now i need to upgrade this environment, i know that i have to upgrade the distributor first but what effect does this have on the replication that is busy running?
That is will all publications and subscription continue to work? What happens during the upgrade? Are the log reader and distribution agents stopped.
What happens when the distributor is upgraded can it still function to the SQL2000 publishers and subscribers?
Or do all publications and subscriptions need to be dropped and recreated after upgrade?
Any comments on how to properly upgrade a SQL2000 replicated environment without disrupting replication (if possible which i doubt) would be greatly appreciated!
Thanx
[780 byte] By [
SeanDL] at [2008-2-16]
All replication activity will be stopped while the distributor machine is being upgraded. As soon as upgrade has completed, and you re-start your agents, replication activity will pick up where it left off. The recommendation is to upgrade the machine during a time where activity is minimal, which is usually late at night or on weekends.No, publications and subscriptions do not need to be dropped and recreated.
But make sure to read the following BOL topics in SQL Server 2005 (this is beta content, and could change before final release) to learn about breaking changes in replication:
Replication Backward Compatibility:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/091c51dc-8b32-4b4f-847e-b317456c8394.htm
Upgrading Replicated Databases:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/9926a4f7-bcd8-4b9b-9dcf-5426a5857116.htm
