Author |
Topic |
Ginger8990
Starting Member
28 Posts |
Posted - 2011-01-26 : 13:28:56
|
I installed SQL 2008 standard on a windows server 2003; Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2) I installed SQL 2008 standard on a windows server 2008 R2 server Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) but the versions of SQL show different builts.Does SQL 2008 automatically change to the different version on 64 bit machine than 32 bit server? |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-01-26 : 13:32:02
|
The instance on the Windows 2003 machine was patched with Service Pack 1 (SP1), which appears in the @@Version string you posted. |
 |
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-26 : 16:36:02
|
If you did not apply SP1 to the first instance, my guess would be that someone slipstreamed the installation media. What that means is that SP1 is automatically applied when you install from the installation media.Jeff |
 |
|
Ginger8990
Starting Member
28 Posts |
Posted - 2011-01-26 : 17:23:08
|
Someone told me if you install SQL server 2008 on a 32 bit server, it will automatically detect 32 bit OS so it will install 32 bit SQL server.If you install SQL 2K8 on 64 bit box, it will detect it and install with 64 SQL 2K8 on 64 bit OS machine.Are they true? |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
Ginger8990
Starting Member
28 Posts |
Posted - 2011-01-27 : 10:32:44
|
It is true. I did a test. I launched the installation wizard, it detected the processor type either 32 bit or 64 bit under options of the first page of installation wizard.I used the same media (network folder), the 32 bit OS pateched since it was installed a few months early.64 bit is recent one.quote: Originally posted by tkizer That is not true. The installation bits are different.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
|
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
kanikacse13
Starting Member
2 Posts |
Posted - 2011-09-15 : 12:14:39
|
Does that I mean in order to get both 32 bit and 64bit instances to same build , SP1 needs to be unistalled. |
 |
|
kanikacse13
Starting Member
2 Posts |
Posted - 2011-09-15 : 12:53:10
|
I got it. In order to get the same build number SP1 can be uninstalled. Just go in Control panel -> add remove programs-> show updates and uninstall it. it will come to BUild number 1600. |
 |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-09-15 : 14:15:42
|
No, you need to install SP1 on the unpatched instance. Perferably install SP2 on both.--Gail ShawSQL Server MVP |
 |
|
|