|
Home > Archive > microsoft.public.cert.mcdba > June 2002 > Upgrading
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]
|
|
|
| Ok, I have one more question...Shouldn't the answer to this question
be D:
You have been hired as an administrator of an SQL Server 2000
computer. The server is running both SQL Server 6.5 and SQL server
7.0. You install a named instance of SQL Server 2000 and run the SQL
Server Upgrade Wizard. During the upgrade process, the database
selection screen fails to list all of the SQL server 6.5 databases.
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.
The answer listed in my exam set is B. however, I was under
impression that in order for you to upgrade from 6.5 to 2000, you need
a default instance of 2000. In addition, unless you install a default
instance of 2000, you won't get any of those upgrade features
including the upgrade folder?
Anyways, what do you think?
| |
| Somchai U. 2002-06-23, 6:15 am |
| just curiously, where does this question come from?
On 12 May 2002 10:53:24 -0700, rkhalili@hotmail.com (RK) wrote:
>Ok, I have one more question...Shouldn't the answer to this question
>be D:
>
>You have been hired as an administrator of an SQL Server 2000
>computer. The server is running both SQL Server 6.5 and SQL server
>7.0. You install a named instance of SQL Server 2000 and run the SQL
>Server Upgrade Wizard. During the upgrade process, the database
>selection screen fails to list all of the SQL server 6.5 databases.
>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.
>
>
>
>The answer listed in my exam set is B. however, I was under
>impression that in order for you to upgrade from 6.5 to 2000, you need
>a default instance of 2000. In addition, unless you install a default
>instance of 2000, you won't get any of those upgrade features
>including the upgrade folder?
>
>Anyways, what do you think?
|
|
|
|
|