2. 计算机
  3. 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

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

admin2009-05-19  23
问题 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.

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.
转载请注明原文地址:https://kaotiyun.com/show/JuhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)