Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Basit's SQL Server Tips

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

Microsoft SQL Server 2008 R2 Builds

The following table lists all builds of SQL Server 2008 R2 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

 Codename RTM/Service Pack Build Number
 Kilimanjaro RTM 10.50.1600.1
SP1 10.50.2500
SP2 10.50.4000

Microsoft SQL Server 2008 R2 Builds Breakdown:

Build File version KB / Description Release Date
10.50.4279 2009.100.4279.0 2830140 Cumulative update package 6 (CU) for SQL Server 2008 R2 Service Pack 2 April 15, 2013 *new
10.50.4276 2009.100.4276.0 2797460 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 2 February 18, 2013
10.50.4270 2009.100.4270.0 2777358 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 2 December 17, 2012
10.50.4266 2009.100.4266.0 2754552 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 2 October 15, 2012
10.50.4263 2009.100.4263.0 2740411 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 2 August 29, 2012
10.50.4260 2009.100.4260.0 2720425 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 2 August 1, 2012
10.50.4000 2009.100.4000.0 SQL Server 2008 R2 Service Pack 2 (SP2) July 26, 2012
10.50.3720 2009.100.3720.0 SQL Server 2008 R2 Service Pack 2 Community Technology Preview (CTP) May 13, 2012
10.50.2874 2009.100.2874.0 2828727 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 1 April 15, 2013 *new
10.50.2861 2009.100.2861.0 Microsoft Security Bulletin MS12-070 October 9, 2012
10.50.2869 2009.100.2869.0 2812683 Cumulative update package 11 (CU11) for SQL Server 2008 R2 Service Pack 1 February 18, 2013
10.50.2868 2009.100.2868.0 2783135 Cumulative update package 10 (CU10) for SQL Server 2008 R2 Service Pack 1 December 17, 2012
10.50.2866 2009.100.2866.0 2756574 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 1 November 6, 2012
10.50.2861 2009.100.2861.0 2716439 MS12-070: Description of the security update for SQL Server 2008 R2 Service Pack 1 QFE: October 9, 2012 October 9, 2012
10.50.2822 2009.100.2822.0 2723743 Cumulative update package 8 (CU8) for SQL Server 2008 R2 Service Pack 1 August 29, 2012
10.50.2817 2009.100.2817.0 2703282 Cumulative update package 7 (CU7) for SQL Server 2008 R2 Service Pack 1 June 18, 2012
10.50.2811 2009.100.2811.0 2679367 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 1 April 16, 2012
10.50.2807 2009.100.2807.0 2675522 FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2 March 12, 2012
10.50.2806 2009.100.2806.0 2659694 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 1 February 22, 2012
10.50.2799 2009.100.2799.0 2633357 FIX: “Non-yielding Scheduler” error might occur when you run a query that uses the CHARINDEX function in SQL Server 2008 R2 February 22, 2012
10.50.2796 2009.100.2796.0 2633146 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 1 December 20, 2011
10.50.2789 2009.100.2789.0 2591748 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 1 October 17, 2011
10.50.2776 2009.100.2776.0 2606883 FIX: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2 October 18, 2011
10.50.2772 2009.100.2772.0 2567714 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 1 August 15, 2011
10.50.2769 2009.100.2769.0 2544793 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 1 July 18, 2011
10.50.2550 2009.100.2550.0 Microsoft Security Bulletin MS12-070 October 9, 2012
10.50.2500 2009.100.2500.0 SQL Server 2008 R2 Service Pack 1 (SP1) July 11, 2011
10.50.1817 2009.100.1817.0 2703280 Cumulative update package 14 (CU14) for SQL Server 2008 R2 June 18, 2012
10.50.1815 2009.100.1815.0 2679366 Cumulative update package 13 (CU13) for SQL Server 2008 R2 April 17, 2012
10.50.1810 2009.100.1810.0 2659692 Cumulative update package 12 (CU12) for SQL Server 2008 R2 February 21, 2012
10.50.1809 2009.100.1809.0 2633145 Cumulative update package 11 (CU11) for SQL Server 2008 R2 January 9, 2012
10.50.1807 2009.100.1807.0 2591746 Cumulative update package 10 (CU10) for SQL Server 2008 R2 October 19, 2011
10.50.1804 2009.100.1804.0 2567713 Cumulative update package 9 (CU9) for SQL Server 2008 R2 August 16, 2011
10.50.1800 2009.100.1800.0 2574699 FIX: Database data files might be incorrectly marked as sparse in SQL Server 2008 R2 or in SQL Server 2008 even when the physical files are marked as not sparse in the file system October 18, 2011
10.50.1797 2009.100.1797.0 2534352 Cumulative update package 8 (CU8) for SQL Server 2008 R2 June 20, 2011
10.50.1790 2009.100.1790.0 2494086 MS11-049: Description of the security update for SQL Server 2008 R2 QFE: June 14, 2011 June 17, 2011
10.50.1777 2009.100.1777.0 2507770 Cumulative update package 7 (CU7) for SQL Server 2008 R2 June 16, 2011
10.50.1769 2009.100.1769.0 2520808 FIX: Non-yielding scheduler error when you run a query that uses a TVP in SQL Server 2008 or in SQL Server 2008 R2 if SQL Profiler or SQL Server Extended Events is used April 18, 2011
10.50.1765 2009.100.1765.0 2489376 Cumulative update package 6 (CU6) for SQL Server 2008 R2 February 21, 2011
10.50.1753 2009.100.1753.0 2438347 Cumulative update package 5 (CU5) for SQL Server 2008 R2 December 23, 2010
10.50.1746 2009.100.1746.0 2345451 Cumulative update package 4 (CU4) for SQL Server 2008 R2 October 18, 2010
10.50.1734 2009.100.1734.0 2261464 Cumulative update package 3 (CU3) for SQL Server 2008 R2 August 20, 2010
10.50.1720 2009.100.1720.0 2072493 Cumulative update package 2 (CU2) for SQL Server 2008 R2 June 25, 2010
10.50.1702 2009.100.1702.0 981355 Cumulative update package 1 (CU1) for SQL Server 2008 R2 May 18, 2010
10.50.1617 2009.100.1617.0 2494088 MS11-049: Description of the security update for SQL Server 2008 R2 GDR: June 14, 2011 June 14, 2011
10.50.1600 2009.100.1600.1 SQL Server 2008 R2 RTM April 21, 2010
10.50.1352 2009.100.1352.12 Microsoft SQL Server 2008 R2 November Community Technology Preview (CTP) November 12, 2009
10.50.1092 2009.100.1092.20 Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP) June 30, 2009

Note: RTM stands for release to market edition, which is the first supported version of SQL Server 2008 R2, and SP stands for service pack. All SQL Server service packs and hotfixes are cumulative, meaning that each new service pack and hotfixes contains all the fixes that are included with previous service packs, hotfixes and new fixes issues.

Please use comment section, if you find build that is not listed here.


Comments

Leave a comment on the original post [basitaalishan.com, opens in a new window]

Loading comments...