SQL Server 2008 R2 Service Pack 2 CTP is available

You can download the Service Pack 2 CTP from the following URL:

http://www.microsoft.com/en-us/download/details.aspx?id=29848

The build # is 10.50.3720. This service pack contains all of the fixes from Service Pack 1 & Cumulative Updates 1 through 5, and a couple of other minor fixes (a couple of SSRS bugs and a bug about an ALTER TABLE batch not being cached correctly). It does not include fixes from Service Pack 1 Cumulative Update #6, which I mentioned recently.

You should *NOT* install this service pack preview if:

  • your build number (SELECT @@VERSION;) is 10.00.xxxx (since this is SQL Server 2008, not SQL Server 2008 R2);
  • your build number is >= 10.50.1815 and < 10.50.2500 (since you may be undoing fixes you are using from RTM CU13); or,
  • your build number is >= 10.50.2811 (since you will be undoing fixes you might be using from SP1 CU6).
     

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

3 Responses

  1. Aaron Bertrand says:

    Larry
    Yes, actually, I did mean preview. This post was written when the CTP of SP2 was released, not the official version.

  2. Larry McPhillips says:

    Aaron in your note "You should not install this service pack preview if"…   did you mean that word "preview"?   I was confused by that, and as far as I know the service pack is not a preview of any sort.

  3. 赵清 says:

    你好!上面的 SQL Server 2008的R2的Service Pack 2 CTP是 下面的地址,现在已经失效,请问如何能找到,帮忙稿知一下,可否,希望你能加我qq281802583