You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows 2000 Server. The Domain.com network contains a SQL Server 2000 database server named Certkiller -DB01 that runs on Windows 2000 Server Service Pack 4. Certkiller -DB01 contains a database named CK_Trading.
Domain.com wants to migrate Certkiller -DB01 to SQL Server 2005 but wants to retain the CK_Trading database with the same instance name. You decide to perform an in-place upgrade to SQL Server 2005. You verify that Certkiller -DB01 exceeds the minimum recommended hardware requirements for SQL Server 2005.
What should you do next?
A.
Upgrade Certkiller -DB01 to Windows Sever 2003 Service Pack 1.
B.
Run the SQL Server Upgrade Advisor on Certkiller -DB01.
C.
Detach the CK_Trading database on Certkiller -DB01.
D.
Run the SQL Server 2005 Setup utility.
Explanation:
Before you perform an in-place upgrade of an existing database, you should run the SQL Server Upgrade Advisor. The SQL Server Upgrade Advisor produces a list of items that must be addressed before and after performing the upgrade. This list of items is specific to the existing installation.
Incorrect Answers:
A: You do not need to upgrade Certkiller -DB01 to Windows Sever 2003 Service Pack 1 as SQL Server 2005 can be installed on Windows 2000 Server with Service Pack 4.
C: You need to detach a database when you need to move the database to another database instance or another database server. You do not need to detach the database before performing an in-place upgrade.
D: You should run the SQL Server Upgrade Advisor before you run the SQL Server 2005 Setup utility. The SQL Server Upgrade Advisor produces a list of items that must be addressed before and after performing the upgrade. This list of items is specific to the existing installation.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: updating databases, detaching and attaching databases