Re: Update MSDE2000 to SQL2000 on same server

Hi,


Yes you do an upgrade from MSDE to SQL 2000 Enterprise. Ensure that you take
a full database backup of all databases (incl system databases).
This can be used as a fallback.

Steps:=

To Upgrade from MSDE 2000 to SQL Server 2000


--------------------------------------------------------------------------------

Step 1 Insert the sql 2000 disc in the CD-ROM drive.

If the CD does not run automatically, browse to the root directory, and
double-click Autorun.exe.

Step 2 Click SQL Server 2000 Components.

Step 3 Click Install Database Server.

Step 4 In the Welcome dialog box, click Next.

Step 5 In the Computer Name dialog box, click Next to accept the default
setting Local Computer.

Step 6 In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an Existing Instance of SQL Server, and click Next.

Step 7 Follow the on-screen prompts until the Upgrade dialog box appears.

Step 8 In the Upgrade dialog box, check the Yes, Upgrade My Programs check
box, and click Next.

Step 9 In the Choose Licensing Mode dialog box.

Step 10 Click Continue.

Step 11 Click Yes to install additional components.

Step 12 In the Select Components dialog box, check the check boxes for the
following components:

..Server Components, and all subcomponents.

..Management Tools, and all subcomponents.

..Client Connectivity.

Step 13 Click Next.

Step 14 In the Start Copying Files dialog box, click Next.

Step 15 Click Finish.

Install SP3a after the successful installation of sql server 2000

Thanks

Hari

SQL SErver MVP


"Alex Delgado" <perfecto_nospam@xxxxxxxxxx> wrote in message
news:eD4ZJ81OFHA.624@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I need to update my MSDE2000 server to SQL2000 server, maintainin
> databases,
> users and admins passwords, because the server is running several
> databases.
>
> Does anyone has any idea on how to perform this?
>
> Thanks a lot.
>
> Alex.
>
>


begin 666 blank.gif
K1TE&.#EA`@`"`( ``/___P```"'Y! $`````+ `````"``(```("A%$`.P``
`
end

.

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: Create SQL cluster on 2003
    ... Since you are in a cluster configuration, ... Microsoft SQL Server MVP ... We only about about 20 databases - all ... Move Databases Between Computers That Are Running SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • 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: SQL Server 2005 and file systems, any recommendations
    ... I had to travel to customer to perform a triple upgrade: ... Had the databases been on plain files, the OS upgrade would have been ... since buffering in the file system could cause problems. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... "In some cases, you may want to copy the system databases, including the ... from the source SQL Server 2000 instance to the SQL ... System Databases" in SQL Server 2005 Books Online to see how to do this" ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
Quantcast