SQL Server R2 does not upgrade 2005 database

  • hi there,

    I am in weird situation, i am upgrading (in place) 2005 to 2008 r2. step 12 where it ask for features, it does not let me select the database engine. it picks up only the component.

    After upgrade the the database still shows version 9.

    i tried to run the add features to upgrade the database but it is asking for different instance name. I want to do the in-place so it can overwrite the existing instance.

    I tried to search everywhere but can't find my answer.

    am i missing something.

    viren

  • What is the Edition of SQL Server 2005 and what is the Edition of SQL Server 2008 R2?

    And finally, what is the OS version that you are installing on?

    If you are trying to install an Enterprise Edition on a desktop OS it will not allow you to upgrade or install the database engine.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • I've seen the same behaviour.

    You'll have to alter the dblevel yourself if desired (even for system db)

    That's one of the reasons why I don't upgrade an instance, but prefer to start a new install and move the user db.

    Of course that may also depend on the features inventory of the instance and on its external connections (e.g. ssb, ..)

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • ALZDBA (5/22/2011)


    I've seen the same behaviour.

    You'll have to alter the dblevel yourself if desired (even for system db)

    Not compat level. He said the DB engine wasn't available for install.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • .... After upgrade the the database still shows version 9. ...

    Must have confused me.

    Did the upgrade succeed or didn't it ?

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • hi there,

    it is 2005 sp2 standard and i am trying to upgrade it 2008 R2 enterprise. Operating system is win 2003. Documents says you can upgrade 2005 std to 2008 r2 enterpise.

    it only upgrades the components and will not pick the database engine.

    I thought i might need to do add feature After upgrade, so i tried to do that then system prompt to create a new instance and i got stuck, because i don't want to do it side by side.

  • SQL 2005 32 bit or 64 bit? Are you installing 32 bit or 64 bit?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (5/23/2011)


    SQL 2005 32 bit or 64 bit? Are you installing 32 bit or 64 bit?

    Good call - would be my next question also. But, just to verify I would like to see @@version from the existing system.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • server is 32 bit. The DVD i received does not say 32 or 64. But it has directory for 32 and 64. I am assuming it is by default picking up 32.

  • Don't assume.

    The last tab on the installer (right at the bottom, below the 'install' and 'documentation' options) shows 32 bit or 64 bit.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • it is X86 which 32 bit.

  • it is 32 bit

  • What is 32-bit, is it the OS or the installation media?

    SQL Server 2008 (and above) is a combined installation media and will default to the OS that you are installing on.

    So, if Windows is x64 and you are trying to run an upgrade - it will only allow you to upgrade the client tools because those are x86 on either type of OS. It will not allow you to upgrade the existing database engine because you cannot upgrade from x86 to x64.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Server is 32 bit and

    One media

    i go to the setup -> installer->option

    It shows processor type x86.

  • dear jeffry

    @@version

    Microsoft SQL Server 2005 - 9.00.3068.00 (Intel X86) Feb 26 2008 18:15:01 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    msinfo32

    System TypeX86-based PC

    Processorx86 Family 15 Model 2 Stepping 6 GenuineIntel ~2200 Mhz

    Processorx86 Family 15 Model 2 Stepping 6 GenuineIntel ~2200 Mhz

    Processorx86 Family 15 Model 2 Stepping 6 GenuineIntel ~2200 Mhz

    Processorx86 Family 15 Model 2 Stepping 6 GenuineIntel ~2200 Mhz

    So i am sure it is 32 bit operating system and 32 database engine. As you said media is intellegent enough to pick 32 bit installation automatically. It should be picking up 32 bit database engine and upgrade it.

Viewing 15 posts - 1 through 15 (of 16 total)

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