YOU HAVE SQL SERVER 2005 REPLICATION AND DECIDED TO UPGRADE IT TO...

19. You have SQL Server 2005 replication and decided to upgrade it to SQL

Server 2008. In which order do you perform an upgrade to SQL Server 2005

for replicated databases to SQL Server 2008?

A. Distributor, Publisher, then Subscriber

B. Publisher, Distributor, then Subscriber

C. You cannot upgrade SQL Server 2005 to SQL Server 2008

D. Any order

Answer A is the correct answer. The Distributor must be at the same or

greater version than the Publisher to receive changes. The Subscriber must

then be equal to or less than that of the Publisher.