Wednesday, March 21, 2012

Installing SQL Server 2005 SP2

Hello,
We are running SQL Server 2005 SP1 Developer Edition x64 on Windows 2003
Server R2 x64. We have setup transactional replication. The same instance
has the Distributor and Subscriber, and another instance has the Publisher.
The readme for SP2 says to upgrade the Distributor, Publisher and then the
Subscribers. Will we have any problems since the same instance is acting as
the Distributor and Subscriber? Which instance should we upgrade first?
Thanks,
Heather
Interesting question. I guess you'll have to do the dist/subs first then the
publisher as this is the nearest to the published expectations. Be nice for
BOL to be updated with clarification for this type of case - I'll put in a
BOL feedback.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

No comments:

Post a Comment