Re: Upgrading of SQL server Standard to SQL server Enterprise.

Hi Jay,

No Issues at all. You could see the detailed steps to upgrade the versions
in SQL 2000 books online (Topic Editions Upgrade).

Steps from Books online.

To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000

1.. Insert the Microsoft® SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.


2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.


3.. In Computer Name dialog box, select Local Computer or Remote computer.


4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.


5.. In the Instance Name dialog box, click Next.


6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.


7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.


8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.

9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.


10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.




Thanks
Hari
SQL Server MVP


"Jay Bukstein" <Jay Bukstein@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3AD8CA03-120B-4EF1-AA6B-CC4E4906AB41@xxxxxxxxxxxxxxxx
> Is there any problems upgrading from SQL Server Standard edition to SQL
> Server Enterprise Edition?


.

Relevant Pages

  • Re: SQL Server Std over SBS 2003 std
    ... What Henry is referring to is that SBS2003 Premium comes with SQL2000 ... Sorry if I sound dumb but SQL is a whole new topic for me. ... You could just install SQL Server std on the SBS Box (that is what an ... You could also upgrade to SBS 3002 R2 Premium with SQL Server 2005 ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint Upgrade to SQL Server Halts at Setup is Preparing to Copy Files
    ... associated SQL Agents/dependant services and then start the upgrade or 2) ... Once the other instances are stopped see if the setup continues.. ... > We already have SQL Server installed on our server prior to this upgrade, ...
    (microsoft.public.windows.server.sbs)
  • Re: Concurrent query problem
    ... SQL2000 personal edition can be upgraded to SQL2000 standard edition.Refer ... How to perform an edition upgrade within SQL Server 2000 ... To upgrade a SQL Server 2000 installation to a different edition of SQL ...
    (microsoft.public.sqlserver.server)
  • Re: How to upgrade from SQL 2000 Standard to SQL 2000 Enterprise Editi
    ... To upgrade a SQL Server 2000 installation to a different edition of SQL ... If Setup detects that you are doing an edition upgrade, ...
    (microsoft.public.sqlserver.setup)
  • Re: Update MSDE2000 to SQL2000 on same server
    ... Yes you do an upgrade from MSDE to SQL 2000 Enterprise. ... a full database backup of all databases. ... Step 2 Click SQL Server 2000 Components. ...
    (microsoft.public.sqlserver.setup)