How to get version/build# from SQL install media?

Question

I'm in the process of turning up a new SQL server and I'm trying to find out what the build number is before I install.  I've seen on other installation media that I could access the MediaInfo.xml file on the root of the CD/DVD.  In this case, there is not version listed, nor does it state the build number.

The output I receive from the aforementioned xml file is the following:

<?xml version="1.0" encoding="UTF-8"?>
<MediaInfo>
  <Properties>
    <Property Id="MediaLayout" Value="Full" />
  </Properties>
</MediaInfo>

Does anybody know of another way to get this info?

---

There is always a way...

Answer 1

I think I may have found the answer...

Right-click on the setup.exe and go to Properties and select the "Details" tab.

---

There is always a way...

Answer 2

Hello, good to know but while installing your SQL server you should be aware of what edition you are applying and what version it is(like 2005 or 2008/R2 or 2012)

Get details about your Microsoft product and its editions-
http://www.microsoft.com/sqlserver/en/us/default.aspx
http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx

---

Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

Answer 3

Can you please look it in default.htm under Server folder?

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful, if a post was useful to help other user's find a solution quicker.

Answer 4

there is a mediainfo.xml file in the root ( smae foler as Autorun.inf) in the cd here you will get the build number( look up build numbers here )

Copied from wikipedia

Version	Description	SQL Server version	Release date
10.50.1450.3	RC0	SQL Server 2008 R2	_
10.50.1600.1	RTM	SQL Server 2008 R2	2010 April 20
10.50.1702.0	CU1	SQL Server 2008 R2	2010 May 17
10.50.1720.0	CU2	SQL Server 2008 R2	2010 June 21
10.50.1734.0	CU3	SQL Server 2008 R2	2010 August 16
10.50.1746.0	CU4	SQL Server 2008 R2	2010 October 18
10.50.1753.0	CU5	SQL Server 2008 R2	2010 December 20
10.50.1765.0	CU6	SQL Server 2008 R2	2011 February 21
10.50.1770.0	CU7	SQL Server 2008 R2	2011 April 18
10.50.1790.0	MS11-049	SQL Server 2008 R2	2011 June 14
10.50.2500.0	SP1	SQL Server 2008 R2	2011 July 12
10.50.3720.0 (kb en-us)	SP2 CTP	SQL Server 2008 R2	2012 May 14
11.0.2100.60	RTM	SQL Server 2012	2012 March 6
11.0.3000.0	SP1	SQL Server 2012	2012 November 9

---

Jayanth Kurup - www.enabledbusiness.com

Answer 5

I assume that you are looking for the build no of either 2008 or 2008 R2 ! If it other then this then reply back ..


Details of sql server 2008 & 2008 R2

-- The SQL Server 2008 builds that were released after SQL Server 2008 was released
http://support.microsoft.com/kb/956909

-- The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released
http://support.microsoft.com/kb/970365

-- The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 2 was released
http://support.microsoft.com/kb/2402659 
--
-- The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 3 was released
http://support.microsoft.com/kb/2629969  

-- The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released
http://support.microsoft.com/kb/981356

-- The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 1 was released
http://support.microsoft.com/kb/2567616

-- The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 2 was released
http://support.microsoft.com/kb/2730301

Happy New Year :)

------------------------------------
Thanks,Suhas Vallala