Hi All, After installing SQL Server 2005 in Clustering, what are the general post installation tasks that need to be done: http://www.microsoft.com/downloads/...dc-a17b-4f09-b282-c6830fead499&displaylang=en (1) For SQL Server service & SQL Agent service, should I change the property " Affect the group". What else need to be changed. (2) What should be the "Threshold" & "Period" which is there below "Affect the group" property. ( Goto Cluster Admin --> SQL Service --> Right click --> Advanced). Thanks.
Make sure the SQL Server resource is set to affect the group. Often it’s best to leave Agent and FTS (Fulltext, if you are using) to not affect the group but that depends on your business needs. We set the threshold - 5 and period to 3 that brings SQL Services within 3 minutes, so better to check/test failover scenario at your side.
