SQL Server service on active/passive

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,

I have inherited 2 node active/passive SQL Server cluster. I have
noticed that SQL Server service is running on active node only. I was
wondering if this is normal behavior. In case of failover, will SQL Server
service start automatically on passive node? What will happen if new
databases created on while service on active node is running and failover
occurs? I guess, since system specific information is stored in system
tables rather than on share SAN (in our case) drive, I am not sure how will
it be replicated to passive node in case of failover.
I would appreciate if somebody can point me to the articles on this
subject.

Thanks,
Igor


.

Relevant Pages

  • Re: Clustering with 2 active nodes and 1 passive node
    ... Mike Epprecht, Microsoft SQL Server MVP ... >> If you have 2 nodes, one sits around waiting for a failover. ... >>> we are being asked to setup a 2 active node, 1 passive node environment. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering with 2 active nodes and 1 passive node
    ... > You have an instance of SQL Server running on an node. ... > If you have 2 nodes, one sits around waiting for a failover. ... >> we are being asked to setup a 2 active node, 1 passive node environment. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server service on active/passive
    ... > I have inherited 2 node active/passive SQL Server cluster. ... > noticed that SQL Server service is running on active node only. ... the node that runs the SQL instance is the active node. ... > In case of failover, will SQL Server service start automatically on ...
    (microsoft.public.sqlserver.clustering)
  • Conditions for Cluster to failover..
    ... Under what conditions will the active node fail to the passive node when ... Does it failover if the CPU on active node is pegged at 100%? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Dear Ekrem
    ... I do not think you know the difference between Two Active Nodes in a Cluster or only one active node. ... When you have only one active node in your cluster, then you will be able to use only one SQL Server server at one time. ... So they said that they want to keep a live copy of their databases on the second node that's why they wanted two active nodes. ...
    (microsoft.public.sqlserver.setup)