SQL Server, rotates between Active and Passive node

microsoft.public.sqlserver.server - Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.


SQL Server >> rotates between Active and Passive node

by Raymond Fang » Thu, 16 Sep 2004 22:37:21 GMT

Hi, all.

Do anyone rotate the active and passive nodes in your cluster? From hardware
wear and tear point of view, it sounds reasonable.

Please share your thoughts.

Thanks!



Top

SQL Server >> RE: rotates between Active and Passive node

by TWlrZSBFcHByZWNodCAoU1FMIE1WUCk » Thu, 16 Sep 2004 22:51:03 GMT


Hi

I would not be worried about wear and tear....the hard drives are the ones
getting it, and they are shared.

From a confidence point of view, yes. You know the failover works and that
there are no problems with the node.

Regards
Mike





Top
Similar Threads

1. Active/Passive Cluster - Can the passive node be safely ustili 

Thanks for your comments Edwin.

"Edwin vMierlo [MVP]" wrote:

> 
> >
> > Also, we know that a single node could comfortably support both instances
> of
> > SQL Server in the event of a failover but I would have no issue with
> > immediately stopping the named instance in order to grant full resource to
> > the production instance.
> >
> 
> That would be my only concern, but as you are confident that it can take the
> load, then you should answer the question yourself !
> Make sure you are also confident that IO paths (storage/network) can take
> the load.
> 
> rgds,
> Edwin.
> 
> 
>

2. Clustering with 2 active nodes and 1 passive node

3. Three Node cluster - Active /Active /Passive 

Hello everybody,

We are trying to consolidate our servers, by moving databases to instances 
(3 nodes) running under Active /Active /Passive mode.

My doubts here are 

(1) Can we ever do this? I said "Yes", it may be possible but never tried.
(2) If yes, how many virtual servers would we need (two or three)?
(3) Now with passive Node how it is going to work if both the servers were 
to fail?

TIA

4. 3 nodes active/active/passive cannot failover

5. Three Node cluster - Active /Active /Passive

6. sharing a resource between nodes in active/passive cluster

7. Cluster problem sql server 2000 active/passive is running on both nodes 

Hello,

Today, during work, suddenly my sql server was stopped, cluster
started failover. Did not switch node but started sql on the same
active machine. After that I got message that on passive machine also
sql server service is running :(
I tried to stop sql on passive node from Service Manager but I also
stopped cluster.
Do you know how to stop sql server on passive node and what could be
the reason??

Any help appreciate .

Cheers,
Bartek

8. 3 Active and 1 Passive Node Cluster in Windows 2003 Server with SQL 2000 SP4