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.
Bạn đang xem 19. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P156 PDF