Upgrading MSDE

From: Johnny (anonymous_at_discussions.microsoft.com)
Date: 02/22/04 

Date: Sat, 21 Feb 2004 19:05:31 -0800

Here's the situation.
Last weekend I installed SBS2K3 Premium Edition, also
installed SQL 2000 from the Premium Technologies cd +
SP3a to the default instance.

Last night (after reading the instructions for installing
SQL) it said to upgrade the MSDE instance that was
installed during the SBS2K3 server install (I never did
this last weekend) So I followed the instructions to do
so, up to the last screen where it was going to start
copying the files for the upgrade. Everything was running
smooth (All screens defaulted the way they were supposed
to)

Before I clicked "Continue" to upgrade the instance ~ I
decided it was probably best to backup my default
instance that was installed the weekend prior (just in
case). So I backed out of all the screens for the
upgrade, then finally "cancling" out of the upgrade all
together. Then I backed up my SQL database and went back
into the upgrade process for the MSDE.

It is now, that it doesn't give me the option to upgrade
the instance anymore. It did the first time, but not
anymore.

My only options are to:

1) Add new options
2) Remove options

How can I tell if the MSDE has been upgraded to the level
it should be at. And what level should that be?
TIA
-J.

Relevant Pages

  • Re: MSDE vs SQL2000 vs SQL2005 Express
    ... Should I upgrade from MSDE to full SQL2000 that came with SBS? ... ..Now that SQL 2005 Express is out perhaps I should just upgrade directly to ... good and bad things about installing SQL 2005 Express on a SBS2003 Server. ...
    (microsoft.public.windows.server.sbs)
  • RE: NT4.0 to 2003
    ... I'd give up on the idea of installing NT on the new server unless ... Promote it to the PDC ... Upgrade the temp PDC to Server 2003 and have it be the first AD Domain ... Assuming you go the round about way I'm suggesting you won't be installing ...
    (microsoft.public.windows.server.migration)
  • Re: upgrade by hand
    ... > the info seems to center on using cvsup and port upgrade, ... > upgrading from 'most any prior freebsd' to latest production release? ... Are you installing 6.0-RELEASE from scratch or building from source? ... then it's still a good idea to start with a full backup. ...
    (freebsd-questions)
  • 2.6.15-1-686 Kernel Wont Upgrade
    ... Packages(media player upgrade in order to play vider). ... installing new version: Operation not permitted". ... The following packages have been kept back: ... localepurge: checking system for new locale ... ...
    (Debian-User)
  • Re: Sharepoint Upgrade from MSDE to SQL 2000 after SP1 fails! Need ad
    ... Attempting to install SQL after SP1 and upgrade the MSDE Sharepoint DB for Indexing, ... The wizard completes fine, but when attempting to turn on the Indexing server, message stating that it is MSDE still. ... I have tried installing again and upgrade the Sharepoint MSDE and it will not work. ...
    (microsoft.public.windows.server.sbs)