Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL version

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

Posted - 2011-01-26 : 13:30:53
You used the same installation media?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

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?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-26 : 17:31:17
That is not true. The installation bits are different.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-27 : 12:50:40
Maybe your installation media is different than mine then.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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.
Go to Top of Page

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.
Go to Top of Page

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 Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -