Multiple choice technology databases

The term “in-place upgrade” refers to which type of upgrade?

  1. Installing SQL Server 2005 in the same directory as the current installation and replacing the SQL Server files

  2. Installing a new instance of SQL Server 2005 and sharing the older databases between the new instance and the old instance

  3. Installing a new instance of SQL Server 2005 on the same server as the old instance and moving the databases from the old instance to the new instance

  4. Installing a new instance of SQL Server 2005 on a different server from the old instance and moving the databases from the old server to the new server
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

An in-place upgrade means installing a new version of SQL Server in the same directory as the existing installation, replacing the old files while keeping the same instance. This is different from side-by-side migration where a new instance is created. In-place upgrades are simpler but riskier because they modify the existing installation directly without a fallback option.

Keep practicing — related questions