November 17, 2009 at 7:15 pm
Hi,
I am going to install sql 2005 clustering. I have a doubt I had checked the two clustered servers in my organization. For the 1st server in the sql server resource properites it says restart and effect entire group. But for the 2nd server in the sql server resource properties it says restart and does not effect entire group. Which is the best one and do you have any articles or sites which clearly explains this. I am planning to set dependencies in the below manner. Can anyone tell me whether this is correct or not.
Resource Dependencies
SQL IP Address (Virtual Server Name) NONE
SQL Network Name (Virtual Server Name) SQL IP Address
SQL Server Disk Resource(s),SQL NetworkName
SQL Server Agent SQL Server
November 18, 2009 at 1:36 am
SQL IP Address (Virtual Server Name): NONE - correct, no remote access without an IP address
SQL Network Name (Virtual Server Name): SQL IP Address - correct, the network name is associated with the IP address, so without an IP address, you can't have the name
SQL Server Disk Resource(s): SQL NetworkName - Not necessarily, just because you haven't got a network name doesn't mean you don't want to bring the disks online.
SQL Server Agent SQL Server - correct, SQL Agent needs SQL Server
You haven't listed the SQL Server dependencies, so I would expect them to be:-
SQL Server: SQL Server Disk Resource(s), SQL NetworkName
As far as the question about restart and affect the group is concerned, that is set individually for each resource.
Restart specifies whether or not you want the cluster service to restart the resource if it fails... this is usually set to yes.
Affect the group specifies whether or not you want the whole resource group failed over if that resource fails. That is up to you... for example, you may not want to fail everything over just because SQL Agent fails or a File share fails.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply