Re: How does the checking of IsAlive is being done

Tech-Archive recommends: Fix windows errors by optimizing your registry



Comments Inline
"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message news:OohS9rs0HHA.4184@xxxxxxxxxxxxxxxxxxxxxxx
Hello there

From some offical documentation about sql server failover clustering i've understand that sql service manager do checkes of IsAlive on each node.

On which mechine it exist on.
Technically, the "Cluster" issues gloabal LooksAlive and IsAlive checks to each virtual server. The exact nature of the checks varies depending on the nature of the virtual application (SQL, Exchange, File SErvice, etc.) The "Cluster" is actually a virtual construction handled by the cluster service on each node. So your question really does not have any meaningful answer.


And do i install virtual server on the nodes and not sql server?

Virtual Server is a product for virtualization but is unrelated to clustering. Clustering creates "Virtual Servers", which are unique to clustering but are not the same as a Virtual Server for pure virtualization. In programming, "Virtual Server" would be considered an overloaded operator.

and where do i install sql server?
First create the cluster. Then install SQL on a node that owns the disk resource you wish to use as your first data disk. If you create a Clustered install, SQL will handle installing on the remaining nodes "behind the scenes".




--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


.



Relevant Pages

  • Re: Cant get SQL 2000 installed on new node in Cluster
    ... You can apply a service pack to a new node without taking the Virtual SQL ... server offline. ... When the install is asking for a virtual server name, ... So which of the two virtual server names do we use: the one for the MSCS cluster or the one for the SQL cluster? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster IP Address change
    ... I've heard the same story from...after not hearing this in 2 years of SQL ... After changing sql ip address resource & sql name resource came online but ... sql server resource was failing. ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: 4 Queries about DB clustering
    ... I support the Professional Association for SQL Server ... First you install MSCS (Clustering). ... >> on a single logical device physically connected to all host nodes. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Choosing correct high availability setup
    ... normal SQL startup, DB integrity check, roll back non-committed ... MVP - Windows Server - Clustering ... Basically there will be an Access database that arrives via FTP at ...
    (microsoft.public.sqlserver.clustering)