You are the administrator of a SQL server computer. The server is running SQL Server  6 . 5  and SQL Server  7 . 0 . You install a named instance of SQL Server  2000 , and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server  6 . 5  databases are not listed. You cancel the SQL Server upgrade wizard. You need to ensure that the SQL Server  6 . 5  databases are listed in the wizard.  What should you do?

A. Uninstall SQL Server  7 . 0 , and then rerun the SQL Server upgrade wizard.
B. Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.
C. Create a data transformation services package that imports the databases from SQL Server  6 . 5  to SQL Server
 2000 , and then execute the package.
D. Uninstall SQL Server  2000 , and then reinstall SQL Server  2000  as the default instance.

Ответ D
Объяснение:
Explanation: To run the SQL Server Upgrade Wizard, you must have a default instance of Microsoft SQL Server  2000  installed on your computer.
References:
BOL: Working with Instances and Versions of SQL Server
BOL: Upgrading Databases from SQL Server  6 . 5  (Upgrade Wizard)
Incorrect Answers:
A: It is not necessary to uninstall SQL Server  7 . 0 . Just install SQL Server  2000  as the default instance.
We cannot run the SQL Server upgrade wizard unless SQL Server  2000  is installed.
B: To run the SQL Server Upgrade Wizard, you must have a default instance of Microsoft SQL Server  2000  installed on your computer.
C: We want to ensure that the SQL Server  6 . 5  databases are listed in the SQL Server  2000  installation wizard. To create DTS transformation packages that upgrade SQL Server  6 . 5  databasees to SQL Server  2000  databases we must install SQL Server  2000  first.

Ответ B.
Объяснение:
Explanation: We want to see the SQL Server  6 . 5  databases when we run the SQL Server upgrade wizard. Wemust use version switching and switch from SQL  2000 / 7 . 0  to SQL Server  6 . 5  before we start the SQL Server upgrade wizard. Note: SQL Server  2000  can be installed on the same computer with Microsoft SQL Server version  6 . 5 , but only one version can be active at one time. To perform a version upgrade of SQL Server  6 . 5  to SQL Server  2000 , you must run the SQL Server Upgrade Wizard from a computer on which you have installed SQL Server  2000 . To run the SQL Server Upgrade Wizard, you must have a default instance of Microsoft SQL Server  2000  installed on your computer. References: BOL: Working with Instances and Versions of SQL Server BOL: Upgrading Databases from SQL Server  6 . 5  (Upgrade Wizard)
Incorrect Answers:
A: It is not necessary to uninstall SQL Server  7 . 0 . Just install SQL Server  2000  as the default instance. We cannot run the SQL Server upgrade wizard unless SQL Server  2000  is installed.
C: We want to ensure that the SQL Server  6 . 5  databases are listed in the SQL Server  2000  installation wizard. To create DTS transformation packages that upgrade SQL Server  6 . 5  databases to SQL Server  2000  databases we must install SQL Server  2000  first.
D: We must switch version to SQL Server  6 . 5  before we start the SQL Server upgrade wizard.