|
Home > Archive > SQL server exams > December 2002 > Both answers seem correct?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Both answers seem correct?
|
|
|
| You are the administrator of an 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.
Answer: B or D | |
| ksoden 2002-12-01, 7:43 am |
| I think the answer would be D. You can only upgrade SQL Server 6.5 to the default instance, not a named instance. | |
| sjgross 2002-12-02, 12:43 pm |
| I'm a bit confused then.
BOL states:
Upgrading from SQL Server 6.5 to SQL Server 2000
After installing Microsoft® SQL Server™ 2000, you can upgrade your SQL Server version 6.5 server configuration and databases using the SQL Server Upgrade Wizard. In this process, SQL Server 6.5 information and data is transferred to a SQL Server 2000 installation. The SQL Server 6.5 installation remains intact on the computer. It can be removed, or kept on the computer and used in a version switch configuration with SQL Server 2000.
It doesn't say anything about SQL 2000 having to be the default instance for the upgrade to work.
But of course, I just started studying for the 70-229 and perhaps I am missing something.
Best,
Susan | |
| ksoden 2002-12-02, 7:11 pm |
| I see what you mean,
check out this Microsoft article and white paper on Upgrading to SQL Server 2000. It's probable more than you ever wanted to know, but look at the note on page 9, below the first paragraph under the heading "Upgrading Databases from SQL Server 6.5 to SQL Server 2000".
The note states: "To run the SQL Server Upgrade Wizard, you must have a default instance of Microsoft SQL Server 2000 installed on your computer".
You can find it here.
http://www.microsoft.com/sql/howtobuy/howtoup.asp
If the link breaks or you have trouble with the download, let me know and I can email you the white paper directly.
Best of luck on the 70-229, Susan.
Still studying for the 70-228 myself.
Kevin | |
| sjgross 2002-12-03, 11:33 am |
| Thanks so much for that reference! I downloaded the whitepaper and saw the note you mentioned.
I've added it to my study notes
Best,
Susan |
|
|
|
|