October 27, 2005 at 8:43 am
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
October 27, 2005 at 9:11 am
Yes, you must install them on both nodes.
-SQLBill
October 27, 2005 at 10:32 am
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.
October 28, 2005 at 5:18 am
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
October 28, 2005 at 5:45 am
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.
October 28, 2005 at 7:10 am
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.
October 28, 2005 at 11:49 am
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