May 21, 2011 at 10:02 pm
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
May 22, 2011 at 10:57 am
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
May 22, 2011 at 1:17 pm
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
May 22, 2011 at 2:23 pm
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
May 23, 2011 at 12:45 am
.... 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
May 23, 2011 at 9:28 am
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.
May 23, 2011 at 9:33 am
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
May 23, 2011 at 10:21 am
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
May 23, 2011 at 10:30 am
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.
May 23, 2011 at 11:57 am
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
May 23, 2011 at 12:06 pm
it is X86 which 32 bit.
May 23, 2011 at 12:22 pm
it is 32 bit
May 23, 2011 at 1:02 pm
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
May 23, 2011 at 1:46 pm
Server is 32 bit and
One media
i go to the setup -> installer->option
It shows processor type x86.
May 23, 2011 at 2:19 pm
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