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 4 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:28 PM

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

  • 12 Feb 2013 1:26 PM

    Richard Mueller edited Revision 15. Comment: Removed (en-US) from title, add 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.

  • 5 Apr 2012 2:00 PM

    Horizon_Net edited Revision 11. Comment: added language tags

  • 6 Sep 2011 3:26 PM

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

  • 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.

  • 18 Jul 2011 10:25 AM

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

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 5 Apr 2012 2:00 PM

    Horizon_Net edited Revision 11. Comment: added language tags

  • Posted by
    on 6 Apr 2012 7:06 AM

    Boumerlin, We provided links and answers to the other questions (very specific questions). We're currently looking into this scenario for you. Thanks!

  • Posted by
    on 9 Apr 2012 10:20 AM

    Paul, we updated the text to make it less confusing. Please let us know if there are still any issues.

    Thanks!

  • Posted by
    on 9 Apr 2012 10:22 AM

    Boumerlin,

    Just to be clear, are you asking for a 2008 R2 version of this KB article...? support.microsoft.com/.../958734

    Thanks!

  • Posted by
    on 9 Apr 2012 10:27 AM

    Boumerlin,

    It looks like this KB article... support.microsoft.com/.../958734

    ...Also applies to...

    • Microsoft SQL Server 2008 R2 Enterprise

    • Microsoft SQL Server 2008 R2 Standard

    ...per the "Applies to" section.

    I'll add a link to this KB article as a section in this Readme. Thank you.

  • Posted by
    on 9 Apr 2012 10:31 AM

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

  • Posted by
    on 9 Apr 2012 10:35 AM

    Okay, I added the "Failover Clustering Rolling Patch and Service Pack Process" section. Please let me know whether or not it meets the need. Thanks!

    Ed

  • Posted by
    on 12 Apr 2012 8:56 AM

    So, the Management Studio download is a subset of the full SP1 download and SP1 will update both or do we have to run both?

  • Posted by
    on 12 Apr 2012 11:15 AM

    BoatSeller,

    You can just leave SSMS and run the SP1 to update both. Thanks!

  • Posted by
    on 18 Jul 2012 8:13 AM

    In article (support.microsoft.com/.../958734) in section: (Installing SQL Server 2008 rolling updates on a failover cluster" (1), the command: cluster.exe resource “SQL Network Name (SQLVS1)” /listofowners > c:\SQLVS1_list_of_owners.txt; Switch /listofowners doesn't exists on "Windows Server 2008 R2 Enterprise Service Pack 1" the switch is /listowners.

  • Posted by
    on 21 Aug 2012 7:14 AM

    This an extremely confusing SP1 update. I have SQL 2008 R2 installed already, everything looks like it wants me to perform a new installation of SQL 2008 R2. Where is the button that says "update to SP1"???

  • 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

Page 2 of 2 (28 items) 12