Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
p.shaw3@ukonline.co.uk
Posting Yak Master
103 Posts |
 Posted - 2007-07-14 : 06:37:24
|
| I have been asked to upgrade 5 SQL2000 servers to SQL2005. These servers replicate between each other forming a circle of replication. I am concerned of the implications involved in the upgrade because of the reliance on the replication.Can anyone please give me advice on upgrading where replication is active. Will replication continue to work between 2000 and 2005 servers as it may not be possible to upgrade all the servers in one shot. Any advice on upgrading where replication is already active would be helpfull.Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-14 : 12:42:24
|
| Should upgrade in correct sequence. Distributor first, then publisher, then distributor. |
 |
|
|
p.shaw3@ukonline.co.uk
Posting Yak Master
103 Posts |
Posted - 2007-07-14 : 14:41:01
|
| Thanks. If all the servers cannot be upgraded together ie. in the same night, will replicatioon still work? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-14 : 20:09:34
|
| Yes if you do that in right sequence. |
|
|
|
p.shaw3@ukonline.co.uk
Posting Yak Master
103 Posts |
Posted - 2007-07-15 : 09:09:03
|
| And if done in the correct sequence, will Replication remain active while the version upgrades take place? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-15 : 20:43:02
|
| Should be, but always test on dev environment first. |
|
|
|
|
|
|
Upgrade servers that Replicate