Elliott Whitlow (6/19/2013)
I would consider it 2 complete SQL installs, except that the point to a single set of system and user databases. So in that regard yes there are two. When I refer to binaries I am referring to the application and support code for SQL.You have to do the service pack for each node because each node contains the application and support code for that instance of SQL.
I would clarify one point, and it may be semantic on my part.. An instance may be active on only one node at a time. In an active/passive arrangement this does essentially mean that one node is inactive. The phrase "only one node or instance can be active" is accurate for your installation but not for others. I might be being pedantic, sorry.
CEWII
Thanks, that makes more sense to me now.
Only one thing I know service pack will make changes to application files or code, but may also do some changes on system database, correct?
But since they share the same system databases, if I apply service pack to node2 that is in passive mode, has the system databases got upgraded, but how can it be, it is on active node 1?
Thanks,