Post reply

Upgrade from MSDE

  • August 23, 2005 at 5:39 pm

    #102730

    I have a SQL Server that is running MSDE with production Databases. I wish to upgrade this Server to SQL Server 2000 Standard Edition. What is the best course to take? Should I uninstall MSDE first and then install Standard Edition? Or, can I install Standard Edition on top of MSDE?

    Kindest Regards,

  • August 24, 2005 at 8:02 am

    #584593

    I believe that SQL Server Standard edition, or Enterprise for that matter, will only install on the server versions of Windows 2000 / 2003.  when you install any version of SQL 2000 on a non-server version, it installed the desktop Edition instead of the "full" version.

    Doesn't the MSDE force you to create an instance as well? so the servername is [machinename]\[instancename] rather than a "default" [machinename] instance?

    If the operating system is a server version, you should be able to use the SQL Server Standard disk to reinstall over the top of the MSDE version in order to upgrade it, but I think you need to explicity select the instancename that is already installed. with applications already connecting to the isntance name, this is probably your best course.

    I would just save the mdf's from the MSDE to a safe location, uninstall MSDE and install the full version as a default instance, but you could upgrade as well if you wanted to. Then I'd update the applications to point at the default instance.

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 24, 2005 at 12:48 pm

    #584747

    I just wish to state that I never (really, NEVER NEVER) upgrade an exisiting installation in this fashion. My advice is:

    1. script your logins (sp_help_revlogin is available from MS)
    2. script your tasks/jobs (if any)
    3. detach your database (save the .mdf and .ldf files somewhere)
    4. uninstall MSDE
    5. reboot
    6. install SQL Server Standard/Enterprise
    7. Apply SP4 (if not, SP3A with 'hotfix' 818 at a minimum)
    8. reboot
    9. execute your logins script
    10. execute your tasks/job scrit
    11. attach your database(s)

     

     

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • August 24, 2005 at 5:18 pm

    #584835

    Thanks folks. I will definitely uninstall MSDE first and then install Standard Edition as you have already mentioned, it's a cleaner way of doing it!

    Kindest Regards,

  • August 25, 2005 at 12:38 pm

    #585128

    I remember something about attaching MSDE databases in SQL 2000.  If I remember correctly, they are set to AUTOCLOSE by default in MSDE.  You might want to check that option after you attach the databases to make sure, unless you want them to close.

    JG

     

     

     

  • August 25, 2005 at 1:29 pm

    #585151

    Good catch Jeff !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply