Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (aMicrosof)
  • When: 22 Apr 2011 1:52 PM
  • Last revision by (aMicrosof)
  • When: 15 Feb 2013 11:56 PM
  • Revisions: 19
  • Comments: 28
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  Microsoft SQL Server 2008 R2 SP1 Readme

Microsoft SQL Server 2008 R2 SP1 Readme

Microsoft SQL Server 2008 R2 SP1 Readme

Click here to change the language.

This page is carefully and closely monitored. Any changes you make will be evaluated and then quickly accepted, refined, or reverted.

This Readme document contains important information to read before installing Microsoft SQL Server 2008 R2 SP1. It describes how to obtain SQL Server 2008 R2 SP1, how to find Books Online, how to find Upgrade Advisor, how to find supplemental product information in the Release Notes, and copyright attributions for the product.

Table of Contents

This Readme file is available on your installation media, as well as from this Readme page.

What's New

For information about the new features in SQL Server 2008 R2, see What's New in SQL Server 2008 R2. For information about what is new in SP1, see the Release Notes.

Obtaining SQL Server 2008 R2 SP1

SQL Server 2008 R2 SP1 is available for download at the SQL Server 2008 R2 SP1 download page. Follow the instructions that are provided at the download site for downloading SQL Server 2008 R2 SP1. You can install SP1, even if you only have SQL Server Management Studio installed (where you don't have an instance of SQL Server installed yet).

Use Books Online for Installation Assistance

Find Books Online

SQL Server Books Online is the primary documentation for getting assistance with installing SQL Server. You can view Books Online on MSDN. For documentation on upgrading installed SQL Server 2008 R2 components with a SQL Server 2008 R2 servicing update, see SQL Server 2008 R2 Servicing Documentation.

Find Installation Information in Books Online

The following Books Online topics on MSDN contain important information about installing SQL Server 2008 R2.

Analyze Your Upgrade with Upgrade Advisor

The Upgrade Advisor tool analyzes your current instance of SQL Server and provides important information you should know before upgrading. For more information about SQL Server 2008 R2 Upgrade Advisor, see the Upgrade Advisor section of this Feature Pack download page.

Failover Clustering Rolling Patch and Service Pack Process

This knowledge base (KB) article describes how to apply a Microsoft SQL Server 2008 R2 update to a failover cluster instance. Although the article says "SQL Server 2008", it also applies to Microsoft SQL Server 2008 R2 Enterprise and Microsoft SQL Server 2008 R2 Standard (see the "APPLIES TO" section at the bottom of the article for a full list).

Important

  • If you update a SQL Server failover cluster instance on an active node, SQL Server services will be stopped. This causes SQL Server downtime. To avoid downtime, install a rolling update on passive nodes as explained in this article.
  • To avoid a mixed version of possible owner nodes in the failover cluster instance, use the Cluster Administrator tool (Cluadmin.exe), to remove nodes from the possible owner nodes list in the failover cluster instance. You should avoid having a mixed version of possible owner nodes to prevent possible data corruption.
  • In SQL Server 2008 R2, the cluster service checks the SQL Network Name resource for a list of possible owners. The SQL Network Name resource is also checkpointed. This behavior differs from SQL Server 2005. In SQL Server 2005, the SQL Server resource itself is checkpointed.

Read the Release Notes for the Latest Product Information

The Release Notes provide supplemental information about product behaviors that apply only to this release or that are not documented in this release of Books Online. You can find the Release Notes on the Release Notes page.

Copyright Attributions

  1. This product contains software derived from the Xerox Secure Hash Function.
  2. This product includes software from the 'zlib' general purpose compression library.
  3. Portions of this software are based in part on the work of RSA Data Security, Inc. Because Microsoft has included the RSA Data Security, Inc., software in this product, Microsoft is required to include the text below that accompanied such software:

    Copyright © 1990, RSA Data Security, Inc. All rights reserved.

    License to copy and use this software is granted provided that it is identified as the "RSA Data Security, Inc., MD5 Message-Digest Algorithm" in all material mentioning or referencing this software or this function. License is also granted to make and use derivative works provided that such works are identified as "derived from the RSA Data Security, Inc., MD5 Message-Digest Algorithm" in all material mentioning or referencing the derived work.

    RSA Data Security, Inc., makes no representations concerning either the merchantability of this software or the suitability of this software for any particular purpose. It is provided "as is" without express or implied warranty of any kind.

    These notices must be retained in any copies of any part of this documentation and/or software.
  4. The Reporting Services mapping feature uses data from TIGER/Line Shapefiles provided courtesy of the U.S. Census Bureau (http://www.census.gov/). TIGER/Line Shapefiles are an extract of selected geographic and cartographic information from the Census MAF/TIGER database. TIGER/Line Shapefiles are available without charge from the U.S. Census Bureau. To obtain more information about the TIGER/Line shapefiles, go to http://www.census.gov/geo/www/tiger. The boundary information in the TIGER/Line Shapefiles is for statistical data collection and tabulation purposes only; its depiction and designation for statistical purposes does not constitute a determination of jurisdictional authority, rights of ownership, or entitlement, and does not reflect legal land descriptions. Census TIGER and TIGER/Line are registered trademarks of the U.S. Bureau of the Census.
, , , , , , , , [Edit tags]
Leave a Comment
  • Please add 3 and 3 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 12 Feb 2013 1:26 PM

    Richard Mueller edited Revision 15. Comment: Removed (en-US) from title, add tags

  • 12 Feb 2013 1:28 PM

    Richard Mueller edited Revision 16. Comment: Fixed zero in <a name> tag in heading in HTLM so TOC works properly

  • 18 Jul 2011 10:25 AM

    Nathaniel Scharer [MSFT] edited Revision 6. Comment: Added 765447

  • 5 Sep 2011 1:05 AM

    Ed Price - MSFT edited Revision 8. Comment: Rattanachot seems to have just added "xxxx" after a line, so I'm reverting to Nathaniel's version.

  • 6 Sep 2011 3:26 PM

    Ed Price - MSFT edited Revision 9. Comment: Added statement at top (closely monitored). Also added TOC.

  • 5 Apr 2012 2:00 PM

    Horizon_Net edited Revision 11. Comment: added language tags

  • 9 Apr 2012 10:31 AM

    Ed Price - MSFT edited Revision 13. Comment: Added the "Failover Clustering Rolling Patch and Service Pack Process" section.

Page 1 of 1 (7 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 12 Feb 2013 1:26 PM

    Richard Mueller edited Revision 15. Comment: Removed (en-US) from title, add tags

  • Posted by
    on 12 Feb 2013 1:28 PM

    Richard Mueller edited Revision 16. Comment: Fixed zero in <a name> tag in heading in HTLM so TOC works properly

  • Posted by
    on 22 Apr 2011 10:06 PM

    Is there some error in the first sentence of "Obtaining SQL Server 2008 R2 SP1" section?

    It says "SQL Server 2005 SP4 ...".

  • Posted by
    on 25 Apr 2011 9:57 AM

    @Alex Chuo

    Fixed. Thanks Alex!

  • Posted by
    on 12 Jul 2011 11:58 PM

    Did I overlook  a "how to install" section in BOL for this service pack ?? I really don't like this kind of information dispersal. wiki\bol\url :-(

  • Posted by
    on 13 Jul 2011 7:15 AM

    Download page has link to download SQLManagementStudio, is it necessary to re-install SQL Management Studio? If yes, what is the order (before or after SP1)?

    Thanks for clarification

  • Posted by
    on 14 Jul 2011 10:30 AM

    Same question as TiPi - I don't have an instance on the box but do have SSMS.  Unclear from the Download page and this page what to do to upgrade to SP1 version.  I upgraded a SS2K8R2 instance+tools and the tools build changed, so there ought to be some instructions to us on how to do just the tools SP1 install.  Please...

  • Posted by
    on 14 Jul 2011 11:03 AM

    Poked it with a stick...

    Just run the SP1 exe and it detects the fact that you only have Management Tools installed; it goes ahead and upgrades them cleanly.  Hope this helps, @Tipi.

  • Posted by
    on 18 Jul 2011 10:25 AM

    Nathaniel Scharer [MSFT] edited Revision 6. Comment: Added 765447

  • Posted by
    on 18 Jul 2011 10:33 AM

    @ALZDBA : Please find the updated documentation for installing Service Pack, which says :  SQL Server 2008 R2 Servicing Documentation.

  • Posted by
    on 28 Jul 2011 10:04 AM

    This is a bit confusing - apart from the question already raised regarding the separate packages for SSMS, the instructions say that the Service Pack upgrades Express editions and then one sentence later says that it doesn't and that Express editions have to be reinstalled from new redistributables.  Which is it?

  • Posted by
    on 31 Aug 2011 10:18 PM

    @ALXDBA

    Did you see the installation links? Here's one, but there's a long list of them above:

    go.microsoft.com/fwlink

    Thanks!

  • Posted by
    on 5 Sep 2011 1:05 AM

    Ed Price - MSFT edited Revision 8. Comment: Rattanachot seems to have just added "xxxx" after a line, so I'm reverting to Nathaniel's version.

  • Posted by
    on 6 Sep 2011 3:26 PM

    Ed Price - MSFT edited Revision 9. Comment: Added statement at top (closely monitored). Also added TOC.

  • Posted by
    on 14 Sep 2011 10:21 AM

    Is there not just a simple check list somewhere? Something along the lines of:

    ** Note: Run foo.exe first, then bar.exe. ***

    1. Run foo.exe

    2. Do this

    3. Do that

    4. Run bar.exe

    5. Do this

    6. Do that

    Installation instructions intermingled with all of the (I know, required) legalese, marketing-speak, and links to links which lead to other links makes for a VERY hard time for those in the trenches who just want to install this on a development server to see how it works.

Page 1 of 2 (28 items) 12