Cluster Nodes

  • Hi there, can someone refresh my memory - In a 2 node cluster - Do I have to run the SQL setup on both nodes (2 installations, basically) and then apply the SP* to both nodes?

    More info.:

    (SQL2K on Win2K3, connected to SAN, where the SQL program files are installed on the local C:\ drive, but the DATA and Log files are on the SAN drives) -

      Thanks

  • Yes, you must install them on both nodes.

    -SQLBill

  • That's what I thought, but when I went to install on the second node, the installation asked me what to do with the existing one and if I wanted to upgrade it.  And there is an Enterprise Manager icon which sees all the instances installed on the first node.

    What's the deal with that?

    Thanks

    A.

     

  • Sql server installs the files on both nodes of the cluster during setup (see msdn article)

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_7ab7.asp

  • You only install SQL on the one node. It will apply the changes to all nodes in the cluster.

    The same is true of the service packs (older patches are different and have to be applied manually to both machines).

    You do however have to run the sp for each Instance installed.



    Shamless self promotion - read my blog http://sirsql.net

  • That seems to be the case, one-time installation appears to have taken care of both nodes. 

    While on the subject, anyone knows of a good documentation that shows how the cluster resources in regards to MSDTC, SQL, etc should look like on a successful installation. 

    A.

     

  • If Active/Active configuration - then install on both nodes to each instance.

    Chris Becker MCDBA OCP MyDatabaseAdmin.com

    Chris Becker bcsdata.net

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply