[EN] How to DO IT? Installation SQL Server Service Pack on more than one instance

In previous post I wrote about new stuff: Service Pack 2 Customer Technology Preview for Microsoft SQL Server 2008 R2. In this one I’ll show what’s happen when we install this (and any other) service pack update on more than one instance. In this case I’ve two SQL Server 2008 R2 instances: one in Enterprise Edition and one in Express Edition with Advanced Services (both with SP1 installed). Generally We can use different Service Packs (one for Enterprise and one for Express) but it is not necessary. OK before we start we should download right file – in this case SQLServer2008R2SP2-KB2630455-x64-ENU.exe (349.8 MB) from THIS place. After, we can start:

Capture_SQLSRV2008R2SP2CTP_01

Pic.01 | First step as always is for checking compability and possibility for success installation. Eight rules passed, one skipped (because it is not a cluster environment).

Capture_SQLSRV2008R2SP2CTP_02

Pic.02 | Licence Agreemend SHOULD be read and MUST be accepted.

Capture_SQLSRV2008R2SP2CTP_03

Pic.03 | First instance – JOTARO on SQL Server Enterprise Edition (with SP1)

Capture_SQLSRV2008R2SP2CTP_04

Pic.04 | Second instance – MIFUNE on SQL Server Express with AdvServ. As we see installator found third KEYKO and fourth SQLEXPRESS instances. Both are under SQL Server 2008 Express and this service pack is not appropriate for updating process.

Capture_SQLSRV2008R2SP2CTP_05

Pic.05 | We should check Files in Use for our security, we should know which services are collerated with those instances BEFORE we start update.

Capture_SQLSRV2008R2SP2CTP_06

Pic.06 | And we have collerated service.

Capture_SQLSRV2008R2SP2CTP_07

Pic.07 | When we are ready to update we can look last time for summary before we going further – for SQL Server Express Edition (I apologize my readers, I missed screen for Enterprise Edition)…

Capture_SQLSRV2008R2SP2CTP_08

Pic.08 | and for Shared Features of course.

Capture_SQLSRV2008R2SP2CTP_09

Pic.09 | Installator start update for first instance – SQL Server Enterprise Edition…

Capture_SQLSRV2008R2SP2CTP_10

Pic.10 | and finishing them. next we must waif few minutes (on my laptop about five) before next phase will start.

Capture_SQLSRV2008R2SP2CTP_11

Pic.11 | And the second phase is starting. If we have more instances we will have more phases.

Capture_SQLSRV2008R2SP2CTP_12

Pic.12 | At the end we have GREEN LIGHT and link for summary log.

Capture_SQLSRV2008R2SP2CTP_13

Pic.13 | The last – unfortunatelly we must restart computer. Another one reason for announce maintenance tasks for company.

*** **** ***

After that is really good practice to review summary log. Is not very big, and is not hard to understand, but give us a lot of necessary information: what happened with my server. Let see it.

By default all reports are stored in this folder (and we shouldn’t change it): C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120518_235654\SystemConfigurationCheck_Report.htm

Inside this file we will find informations below:

Overall summary:
  Final result:        Passed but reboot required, see logs for details
  Exit code (Decimal): 3010
  Exit message:        Passed but reboot required, see logs for details
  Start time:          2012-05-18 23:57:06
  End time:            2012-05-19 00:29:57
  Requested action:    Patch

Instance JOTARO overall summary: {FIRST INSTANCE}
  Final result:        Passed but reboot required, see logs for details
  Exit code (Decimal): 3010
  Exit message:        Passed but reboot required, see logs for details
  Start time:          2012-05-19 00:11:19
  End time:            2012-05-19 00:24:42
  Requested action:    Patch

Instance MIFUNE overall summary: {SECOND INSTANCE}
  Final result:        Passed
  Exit code (Decimal): 0
  Exit message:        Passed
  Start time:          2012-05-19 00:24:58
  End time:            2012-05-19 00:29:52
  Requested action:    Patch

Machine Properties:
  Machine name:        WRON023
  Machine processor count:       2
  OS version:          Future Windows Version {WINDOWS 8 CONSUMER PREVIEW}
  OS service pack:             
  OS region:           Ísland
  OS language:         English (United States)
  OS architecture:     x64
  Process architecture:64 Bit
  OS clustered:        No

Product features discovered:
{details in text normally but the graphical looks better, see below}
Product, Instance, Instance ID, Feature, Language, Edition, Version, Clustered

Package properties:
  Description:         SQL Server Database Services 2008 R2
  ProductName:         SQL2008
  Type:                RTM
  Version:             10
  SPLevel:             2
  KBArticle:           KB2630455
  KBArticleHyperlink: 
http://support.microsoft.com/?kbid=2630455
  PatchType:           SP
  AssociatedHotfixBuild:         0
  Platform:            x64
  PatchLevel:          10.52.3720.0
  ProductVersion:      10.50.1600.1
  GDRReservedRange:    10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0
  PackageName:         SQLServer2008R2-KB2630455-x64.exe
  Installation location:         e:\86645666867d6b8cf018fff81c2985\x64\setup\

Updated product edition:
  Instance             Edition            
  JOTARO               ENTERPRISE         
  MIFUNE               EXPRESS_ADVANCED   

User Input Settings:
  ACTION:              Patch
  ALLINSTANCES:        False
  CLUSTERPASSIVE:      False
  CONFIGURATIONFILE:            
  ENU:                 False
  FARMACCOUNT:         <empty>
  FARMADMINPORT:       0
  FARMPASSWORD:        *****
  HELP:                False
  INDICATEPROGRESS:    False
  INSTANCEID:          <empty>
  INSTANCENAME:        <empty>
  PASSPHRASE:          *****
  QUIET:               False
  QUIETSIMPLE:         False
  UIMODE:              Normal
  X86:                 False

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120518_235654\SystemConfigurationCheck_Report.htm

 

Information from file under part: ‘Product features discovered ‘ looks better when we turn SQL Server Setup Discovery Report. Result is much better in table view:

Capture_SQLSRV2008R2SP2CTP_14

[EN] An Exceptional DBA 5th Edition

Probably normally You are DBA (DataBase Administrator). Sometimes You’re Accidental DBA (from time to time, on holiday, or as a “temporary replacement”). But if You working with many databases or just only one, if You are experienced user, or someone think that…. You can take a part in RedGate (more info below) fantastic program:

Exceptional DBA Awards 2012

THE IDEA: This is the funny competition for any DBA, who like work with Instances for example at night, (2 AM?) on Saturday. Or You like look to the SQL Server Health Monitor before Sunday Family dinner? You could be an Exceptional DBA of 2012 year.

RULES: Nominations are open until the 29th June 2012. Anyone currently working as a SQL Server database administrator is eligible. You can nominate either yourself, or a friend or colleague. To enter, you just have to fill in a form on this website, answering a few questions about your career (or your nominee’s career) as a DBA. Five finalists will be chosen by the expert judging panel. The finalists will be announced in July 2012.

PRIZE: Ohh Yeeesss!!! Free entrance for PASS Summit 2012 (with awards ceremony), four nights hotel free and some money for towards of travel expenses. And extra prize for finalists (and winner) from RedGate: SQL DBA Bundle for next 36 months.

For the beginning You should read those free ebooks:

 

Don’t think about it too long. Just:

ENTER & WIN

[EN] SQL Server 2008 R2 Service Pack 2 CTP + Extras are Available

LOGO__SQLServer2008R2SP2Yes. Now it’s official. Few days before May 14th this stuff was available for special groups (preferred customers, and MVP’s) and now is for everyone as Customer Technology Preview. Service Pack 2 for SQL Server 2008 R2 [build: 10.50.3720.0] Of course IS NOT for production environment. Is for preview, testing, observing and generally is for helping Microsoft producing final RTM version. This Service pack contains all updates. If You have SQL Server 2008 R2 environment, You can download, install, test and send feedback to Microsoft SQL Server Team. of course this package have few important solutions for earlier reported errors such as (based form Microsoft site):

  • Reporting Services Charts Maybe Zoomed & Cropped
    Customers using Reporting Services on Windows 7 may sometime find charts are zoomed in and cropped.  To work around the issue some customers set ImageConsolidation to false.  
  • Batch Containing Alter Table not Cached
    In certain situations with batch files containing the alter table command, the entire batch file is not cached.  
  • Collapsing Cells or Rows, If Hidden Render Incorrectly
    Some customers who have hidden rows in their Reporting Services reports may have noticed rendering issues when cells or rows are collapsed.  When writing a hidden row, the Style attribute is opened to write a height attribute. If the attribute is empty and the width should not be zero.  

From my perspective this stuff have another one great feature: at the same time we can use all three parts: Service Pack 2 CTP for SQL Server 2008 R2  and Service Pack 2 CTP for SQL Server 2008 R2 Express and Service Pack 2 CTP for SQL Server 2008 R2 for Feature Pack. Lets look for all parts.

Service Pack 2 CTP for SQL Server 2008 R2  

You can download editions for all platforms: IA64 (335MB), x86 (239MB) and x64 (350MB) and for all editions: Parallel Computing Edition, Datacenter Edition, Enterprise Edition and Developer Edition, Standard Edition, Web Edition, Workgroup Edition.

You will find links and explanations for download at THIS page.

*** **** ***

Service Pack 2 CTP for SQL Server 2008 R2 Express

If You use only Express Edition, You can also use all necessary update from this package, dedicated for all versions: SQL Server Express x64 (182MB) & x86 (161MB) & 32_x86 (140MB); SQL Server Express with Advanced  Services x64 (1005MB) & x86 (891MB); SQL Server With Tools x64 (339MB) & x86 (316MB); SQL Management Studio x64 (188MB) & x86 (184MB). You should still remember about Limitations : SQL Server Express supports 1 physical processor, 1 GB memory, and 4 GB storage.

You will find links and explanations for download at THIS page.

*** **** ***

Service Pack 2 CTP for SQL Server 2008 R2 for Feature Pack.

And last but not only least, last and super interesting part is for all external features. What is Feature Pack? Is fantastic collection of stand-alone packages which provide additional value for SQL Server 2008 R2 SP2. The list of features is very interesting, as usual:

Microsoft® SQL Server Report Builder 3.0 for Microsoft® SQL Server 2008 R2 SP2 CTP
Report Builder 3.0 introduces additional visualizations including maps, sparklines and databars which can help produce new insights well beyond what can be achieved with standard tables and charts. The Report Part Gallery is also included in this release – taking self-service reporting to new heights by enabling users to re-use existing report parts as building blocks for creating new reports in a matter of minutes with a “grab and go” experience. Additionally, users will experience significant performance improvements with enhancements to the ability to use Report Builder in server mode. This allows for much faster report processing with caching of datasets on the report server when toggling between design and preview modes. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010
The Microsoft SQL Server 2008 R2 Reporting Services Add-in for Microsoft SharePoint Technologies 2010 allows you to integrate your reporting environment with SharePoint to experience the benefits of using the collaborative environment provided by SharePoint. Once you install the Reporting Services Add-in and configure your servers for integration, you can publish Reporting Services content to a SharePoint library and then view and manage those documents directly from a SharePoint site. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® 2008 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2007
Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies allows you to take advantage of new SQL Server 2008 report processing and management capabilities in SharePoint integrated mode. This version also includes Report Builder server mode, and the ability to launch Report Builder directly from a Report Server. The download provides a Report Viewer Web part, Web application pages, and support for using standard Windows SharePoint Services 3.0 or Microsoft Office SharePoint Services 2007. | Audience(s): Customer, Partner, Developer

Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2
The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 R2 Integration Services. To install the component, run the platform-specific installer for x86, x64, or Itanium computers respectively. For more information see the Readme and the installation topic in the Help file. | Audience(s): Partner, Developer

Microsoft® System CLR Types for SQL Server® 2008 R2
The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy id types in SQL Server 2008 R2. This component can be installed separately from the server to allow client applications to use these types outside of the server. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® 2008 R2 Remote Blob Store
The SQL Server Remote Blob Store is a method for storing blobs of unstructured data in an external Content Addressable data store. The component consists of a client-side DLL that is linked into a user application, as well as a set of stored procedures to be installed on SQL Server. Run the self-extracting download package to create an installation folder. The setup program contained there will install RBS on X86, X64, and Itanium-based computers. | Audience(s): Developer, DBA

Microsoft® SQL Server® 2008 R2 Upgrade Advisor
Microsoft SQL Server 2008 R2 Upgrade Advisor analyzes instances of SQL Server 2000, SQL Server 2005 and SQL Server 2008 in preparation for upgrading to SQL Server 2008 R2. Upgrade Advisor identifies feature and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.

Microsoft® SQL Server® 2008 R2 Native Client
Microsoft SQL Server 2008 R2 Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 R2 features. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 R2 features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® 2008 R2 Command Line Utilities
The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server 7.0, SQL Server 2000, SQL Server 2005, and SQL Server 2008 and 2008 R2 instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server 2008 R2 and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® Service Broker External Activator for SQL Server® 2008 R2
The Microsoft SQL Server 2008 R2 Service Broker External Activator is an extension of the internal activation feature in SQL Server 2008 R2 that lets you move the logic for receiving and processing Service Broker messages from the Database Engine service to an application executable that runs outside SQL Server. By doing this, cpu-intensive or long-duration tasks can be offloaded out of SQL Server to an application executable, possibly in another computer. The application executable can also run under a different Windows account from the Database Engine process. This gives administrators additional control over the resources that the application can access. Run the self-extracting download package to create an installation folder. Read Books Online for more information. The single setup program will install the service on x86, x64, and IA64 computers. Read the documentation for more information. | Audience(s): Customer, Developer

Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
The Microsoft Windows PowerShell Extensions for SQL Server2008 R2 includes a provider and a set of cmdlets that enable administrators and developers to build PowerShell scripts for managing instances of SQL Server. The SQL Server PowerShell Provider delivers a simple mechanism for navigating SQL Server instances that is similar to file system paths. PowerShell scripts can then use the SQL Server Management Objects to administer the instances. The SQL Server cmdlets support operations such as executing Transact-SQL scripts or evaluating SQL Server policies. | Audience(s): Customer, Partner, Developer 

Microsoft® SQL Server® 2008 R2 Shared Management Objects
The SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services. This object model will work with SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® 2008 R2 ADOMD.NET
ADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2008 R2 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining. Note:The English ADOMD.NET setup package installs support for all SQL Server 2008 R2 languages. | Audience(s): Customer, Partner, Developer

Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2
The Analysis Services OLE DB Provider is a COM component that software developers can use to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2008 R2 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® 2008 R2 Analysis Management Objects
Analysis Management Objects (AMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer Analysis Services objects. | Audience(s): Customer, Partner, Developer

Microsoft® Datamining Viewer Controls For Microsoft® SQL Server® 2008
The Data Mining Web Controls Library is a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2008 Analysis Services in their client-side applications. The controls in this library display the patterns that are contained in Analysis Services mining models. | Audience(s): Customer, Partner, Developer

You will find links and explanations for download at THIS page.

AS ALWAYS: ENJOY!!!