InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 20:34:55 GMT20http://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxThe build list for SQL 2008 has a problem. The top 3 entries for it are incorrect:10.00.5829 2799883 Cumulative update package 9 for SQL Server 2008 Service Pack 3 Three fixes for the database engine. 10.00.5794 2771833 Cumulative update package 8 for SQL Server 2008 Service Pack 3 Nine fixes included in this update. 10.00.5788 2738350 Cumulative update package 7 for SQL Server 2008 Service Pack 3 11 fixes. It should be:10.00.5829 2799883 Cumulative update package 9 for SQL Server 2008 Service Pack 3 Three fixes for the database engine. 10.00.5828 2771833 Cumulative update package 8 for SQL Server 2008 Service Pack 3 Nine fixes included in this update. 10.00.5794 2738350 Cumulative update package 7 for SQL Server 2008 Service Pack 3 11 fixes. Tue, 19 Feb 2013 10:47:21 GMTjcoehttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxHi,Thanks for list it is indeed very useful.I would have one suggestion here in this list if we can add SQL Server CTP build numbers also in it would be very help full to isolate CTP version.Best Regards,NiravThu, 10 May 2012 03:00:15 GMTNirav_Joshihttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxHi All,My personal favorite reference for SQL Server builds of all versions is at SQLSecurity.comCheck it out, left hand side has the versions:[url=http://www.sqlsecurity.com/faqs-1/sql-server-versions ]SQLSecurity.com[/url]Best,AmarettoSlimTue, 27 Mar 2012 15:15:12 GMTAmarettoSlimhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxYes! Just search for "SQL Server 2008 Build" in the main SSC Search box and you'll see both the 2008 and 2008 R2 listed :-DTue, 27 Mar 2012 02:51:24 GMTjts_2003http://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxIs there a similar build list for SQL Server 2008R2?Mon, 26 Mar 2012 12:36:05 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxJust a quick thanks. These updates are always very useful for those of us who don't have time to keep up... Another valuable service of your site!Mon, 26 Mar 2012 07:30:09 GMTMelS-512196http://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxSorry, I don't have anything to do with it, other than being a satisfied user. :-)Wed, 25 Jan 2012 11:32:21 GMTMike Hindshttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxMike, can you please correct the link of SP2 CU5, which points to SP2 CU6?Wed, 25 Jan 2012 11:27:44 GMTjeffrey yaohttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxSteve's done fine (he was my backup). Microsoft is the one that has dropped the ball.Wed, 25 Jan 2012 05:49:08 GMTMike Hindshttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxSeems that we need to update the list so seriously, Steve make someone Admin for incoming updates of the SQL Server!Tue, 24 Jan 2012 10:35:06 GMTDugihttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxMicrosoft SQL Server Release Services ( http://blogs.msdn.com/b/sqlreleaseservices/ )has missed the last release of a Cumulative Update for both SQL 2008 R2 (Dec) and SQL 2008 (this month). Anyone know if they're going to (or have) officially stopped posting notification of hotfixes there?Tue, 24 Jan 2012 08:54:12 GMTMike Hindshttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxHi Steve,The link for SP2 CU5 is wrong (it links to SP2 CU6). The correct link should be http://support.microsoft.com/kb/2555408Thanks,JeffreyWed, 04 Jan 2012 13:59:39 GMTjeffrey yaohttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxHi Steve,Very nice article. Thanks for sharing :)[b]FYI:[/b] I have seen other builds like Build 10.00.2781, Build 10.00.2773, Build 10.00.2770 etc in Microsoft website below.http://support.microsoft.com/kb/970365Thu, 10 Nov 2011 16:56:59 GMTsqlpsqlhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxif you already have SQL2008SP2 with some Cumulative Update Pack (CUP) you should not apply SP3but now that MS have released the first CUP to SP3, you are good to go !http://sqlblog.com/blogs/aaron_bertrand/archive/2011/10/18/cumulative-update-1-for-sql-server-2008-sp3-is-available.aspxso the list needs to add 10.00.5766 entryFri, 21 Oct 2011 02:07:24 GMTdick.bakerhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspx[quote][b]Charles Kincaid (10/19/2011)[/b][hr]I have a client on R2 so:[quote]Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (Hypervisor) [/quote]The backup won't restore onto my SP3 box[quote]Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) [/quote]How can I get around this?[/quote]Please start a new thread. And the short answer is you can't restore down from an upper version.Wed, 19 Oct 2011 19:28:22 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxI have a client on R2 so:[quote]Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (Hypervisor) [/quote]The backup won't restore onto my SP3 box[quote]Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) [/quote]How can I get around this?Wed, 19 Oct 2011 13:47:51 GMTCharles Kincaidhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxSP3 = 10.0.5500Sun, 16 Oct 2011 18:21:30 GMTWildcathttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxHi, Steve, The SQL 2008 build list has something wrong. The current CU is 6, not CU4, and seems you missed CU5, which is 10.0.4316.Mon, 26 Sep 2011 08:44:01 GMTWildcathttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxHi Steve,Thanks for the updated article.For me, I have also used this to find the correct version.SELECT SERVERPROPERTY('productversion')10.50.1600.1Kash InstructorSQL Server Tutorials[url]http://www.learningsqlserver2008.com[/url]Sat, 21 May 2011 06:46:02 GMTKashhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxThank you, Unfortunatly I have to stick with SQL 2008 SP1 for the majority and maybe 1-2 R2 for specific approved applications. To many vendors do not mention R2 as a accepted version. If only I could delay the SQL upgrade a few more months to hound the vendors into testing/approving :). They will probably approve the day after I move the databases to SP1 :).Wed, 18 May 2011 07:13:59 GMTMaramorhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspx[quote][b]matthew.stone (4/1/2011)[/b][hr]Thank you, that does provide a good bit of information. I thought a spot on the 2008 build list would show at what point R2 was started. Like does R2 include SP1 or off the base with no CU or SP. If I understand it is a new release but I don't see much if anything that explains where it spins off the main version.[/quote]Edit : Hadn't seen the 2nd page. Sorry if repost.Good idea. If you still need that info you could look at the link in the post right before yours. That'll give you the R2 history so you can guesstimate at it. You can also think of 2008 R2 as sql 10.5. A little like sql 6 and 6.5. There are defenite improvements, but not enough for a new major version.Wed, 18 May 2011 06:50:59 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxHi allThe original article will be updated when next CU comes?RegardsRodrigo MoraesWed, 18 May 2011 06:41:04 GMTRodrigo Moraeshttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxsomeone forgot to update the download xls :blink:Thu, 21 Apr 2011 03:28:26 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspx[quote][b]matthew.stone (4/1/2011)[/b][hr]Thank you, that does provide a good bit of information. I thought a spot on the 2008 build list would show at what point R2 was started. Like does R2 include SP1 or off the base with no CU or SP. If I understand it is a new release but I don't see much if anything that explains where it spins off the main version.[/quote]Roughly, you can consider SQL 2008 R2 RTM as spun off from SQL 2008 SP1 CU4. SQL 2008 R2 CU1 brings that up to parity with SQL 2008 SP1 CU 7. The intro text for R2 CU1 gives you the clue:[quote]Cumulative Update 1 for Microsoft SQL Server 2008 R2 RTM contains only hotfixes that were released in Cumulative Update 5, 6, and 7 for SQL Server 2008 Service Pack 1 (SP1). Cumulative Update 1 for SQL 2008 R2 RTM is only intended as a post-RTM rollup for Cumulative Update 5-7 for the release version of SQL Server 2008 SP1 customers who plan to upgrade to SQL Server 2008 R2 and still keep the hotfixes from Cumulative Update 5-7 for the release version of SQL Server 2008 SP1. No new hotfixes have been included in this cumulative update.[/quote]However, R2 is not just a rollup of fixes. See the What's New doument at [url=http://msdn.microsoft.com/en-us/library/bb500435.aspx]http://msdn.microsoft.com/en-us/library/bb500435.aspx[/url] for more information.Fri, 01 Apr 2011 15:09:00 GMTjcoehttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxThank you, that does provide a good bit of information. I thought a spot on the 2008 build list would show at what point R2 was started. Like does R2 include SP1 or off the base with no CU or SP. If I understand it is a new release but I don't see much if anything that explains where it spins off the main version.Fri, 01 Apr 2011 14:52:28 GMTMaramorhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxYou need to look here if you want the build list for 2008 R2: [url=http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/70092/]http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/70092/[/url]Fri, 01 Apr 2011 14:08:15 GMTjcoehttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxWhere does R2 fit in this list? I thought if you were installing new systems you should be using R2. Although I have vendors that only go as far as SP1. I have tested several on R2 in a pilot test but technically not supported by vendor since they say SP1.So I am unsure if I should go SP1 or R2 in general. I have some 12 servers that I am hoping to update this year and want to be consistant as best as I can.I really like this build list and have been checking it every now and then.Fri, 01 Apr 2011 13:50:35 GMTMaramorhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxUsually you should avoid going backwards when at all possible. One issue you may come across is if you apply SP2, enable 15K partitions, then try to move that database to anything < SP2 ... good luck. That's a pretty obscure scenario, but other cases exist, such as back in 2005 if you applied SP2 and started using the enhanced metadata functions, your code would break if you deploy the same code to SP1 or RTM.I don't recall if I've ever tried detaching a database from SP2 and attaching it to SP1... I think I always live by my first statement above.Thu, 20 Jan 2011 10:04:21 GMTaaron.bertrandhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxnever had a problemour QA is almost always on a later build than production and we restore databases there. we also have a process to sync databases on a SAN from x64 servers running a very recent SQL build to a windows 2000 server running an earlier version of sql 2005Thu, 20 Jan 2011 09:46:15 GMTalen teplitskyhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxIs there ever a problem with moving databases to other SS2008 servers that have different service packs installed, going from SP2 to an SP1 server or vice-versa?Thu, 20 Jan 2011 09:07:52 GMTBill Taladahttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxAlso CU 10 for RTM incorrectly has SP1 as the label.Sat, 27 Nov 2010 09:27:08 GMTaaron.bertrandhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxNeed to ad SQL 2008 SP1 CU11, 10.0.2804.http://support.microsoft.com/default.aspx?scid=kb;en-us;2413738&sd=rss&spid=13165Tue, 23 Nov 2010 11:01:53 GMTjcoehttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspx[url= http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx]SQLSecurity.com[/url] get's my vote for best overall build list.Fri, 19 Nov 2010 10:54:36 GMTGreg Milnerhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxHi Steve,In the Major Builds box at the top the KB Article given for SP2 is actually the KB article for SP1 :-)By the way, this is probably one of my top references at the mo' while I try and get our instances to some kind of level playing field!Many thanksTue, 09 Nov 2010 08:04:07 GMTjts_2003http://www.sqlservercentral.com/Forums/Topic576343-32-1.aspx[b]Our R2 cluster reports[/b] Microsoft SQL Server 2008 R2 (RTM) - [highlight=#ffff11][b]10.50.1600.1 [/b]([/highlight]X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )Tue, 02 Nov 2010 09:35:42 GMTbob_chauvinhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxbuild 10.50.1600.1 not listed in the build list Mon, 25 Oct 2010 02:22:09 GMTjulian.valoo-866456http://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxack...Fri, 08 Oct 2010 08:12:57 GMThsoj17http://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxSQL Server 2008 SP2 is out![url]http://blogs.technet.com/b/dataplatforminsider/archive/2010/09/29/sql-server-2008-sp2-is-available-for-download-today.aspx[/url]Wed, 06 Oct 2010 07:14:03 GMTWildcathttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspxHere is the one for SQL Server 2008 R2:[url]http://support.microsoft.com/kb/981356/[/url]-EricMon, 27 Sep 2010 11:26:42 GMTenwinnhttp://www.sqlservercentral.com/Forums/Topic576343-32-1.aspx[quote][b]Swirl80 (7/19/2010)[/b][hr]....and SP2 :-D[/quote]It is still CTP (Community Technology Preview)! SP2 for SQL Server 2008 is due to be released in Q4 of 2010.Mon, 19 Jul 2010 07:35:19 GMTDugi