Side by side upgrades are a common choice when installing SQL 2008 alongside an older version of SQL Server such as 2000 or 2005. Which of the following is not an advantage of SQL side by side…

The correct answer is D. Instance naming for connecting applications do not change. You should consider several factors before choosing an upgrade strategy. Your strategy should include the need for component-level upgrade, ability to roll back in case of failure, the size of databases, and whether a partial upgrade is needed

Design an optimized database solution

Question

Side by side upgrades are a common choice when installing SQL 2008 alongside an older version of SQL Server such as 2000 or 2005. Which of the following is not an advantage of SQL side by side upgrades?

Options

ABest suited for very large databases
BAbility to upgrade platforms from 32 to 64 bit
CAbility to run SQL Servers side by side for testing and verification
DInstance naming for connecting applications do not change

How the community answered

(17 responses)

A
6% (1)
B
12% (2)
C
6% (1)
D
76% (13)

Explanation

You should consider several factors before choosing an upgrade strategy. Your strategy should include the need for component-level upgrade, ability to roll back in case of failure, the size of databases, and whether a partial upgrade is needed

Topics

#side-by-side upgrade#SQL Server migration#instance naming#upgrade strategy

Community Discussion

No community discussion yet for this question.

Full 70-450 Practice