Installing HP Insight Software 6.1 Update 1 on Windows Server 2008 R2 Failover Clusters with SQL Server 2008 for high availability

23
Server instance. Click
Move this service or application to another node

M
ove to node
secondary
, where
secondary
is the name of the node just added to the SQL Server failover
cluster. The SQL Server instance group should then failover to the secondary system.
This completes the SQL Server installation on the secondary system.
For additional information on SQL Server 2008, refer to
1.
SQL Server 2008
,
http://msdn.microsoft.com/en
-
us/library/bb418439(v=SQL.10).aspx
.
2.
Microsoft White Papers
,
http://msdn.microsoft.com/en
-
us/library/dd631807(v=SQL.10).aspx
.
3.
High Availability with SQL Server 2008
,
http://msd
n.microsoft.com/en
-
us/library/ee523927(v=SQL.100).aspx
.
4.
Getting Started with SQL Server 2008 Failover Clustering
,
http://msdn.microsoft.com/en
-
us/library/ms189134(v=SQL.100).asp
x
.
Applying updates to SQL Server 2008 Enterprise Service Pack 1
SQL Server uses an Incremental Servicing Model (ISM). The model is described in
An Incremental
Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
,
http://support.microsoft.com/kb/935897/
. Issues that have broad impact, like security, and are
well
-
tested are packaged into General Distribution Releases and distributed through Microsoft Update,
Wind
ows Update or both.
Other hotfixes are released periodically as cumulative updates. These updates must be requested,
see
The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released
,
http://support.microsoft.com/kb/970365/
; and
Cumulative update package 9 for SQL Server 2008
Service Pack 1
,
http://support.microsoft.com/kb/2083921/
. Microsoft recommends that you appl
y
only needed hotfixe
s in production after testing.
There are other more selective delivery mechani
sms
for more critical hotfixes.
A Cumulative Update must be applied to both cluster nodes, one at a time, to the node that
does not
own
the SQL Server cluste
r resources.
Install Insight Software components on the cluster
Insight Software 6.1 Update 1 is the first release of Insight Software to support Windows 2008 R2
Failover Clustering.
By following the previous instructions, you have a two
-
node failover clus
ter with Microsoft Distributed
Transaction Coordinator and Microsoft SQL Server 2008 Enterprise Service SP1 installed as cluster
applications. Resources to create a cluster application for Insight software 6.1 U1 have been
provisioned. Both cluster nodes
are running.
You must complete
configuration steps before starting the installation of Insight Software.
Create cluster group and resources for
Systems Insight Manager
and
Insight Software
Before installing Insight Software, create the cluster group for
Sy
stems Insight Manager
and Insight
Software and add its access point and disk resources. Additional resources
are
added to this group
after Insight Software is installed.
1.
Log in to one of the cluster systems under the SQL/IS Administrator account and start the
Failover
Cluster Manager
.