Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Yesterday a power surge took out our SQL Server. Had to have the motherboard replaced and everything. Not good.

Anyway, I'm now looking into failover clustering to prevent such an event from impacting our business.

Is the concept of failover clustering as follows?

  • Obtain a new server to act as a node

  • Install SQL Server on this server, set up as a failover node

  • Changes to the "live" database are replicated on the failover node

  • If the "live" server goes down, the failover node assumes the identity of the main SQL Server. For example, if the "live" server is named "CO-SQL", the node will then assume that identity so it can be found on the network.

Is that about right?

share|improve this question
1  
no there is no data replication its shared storage. –  tony roth Jun 13 '12 at 13:53
2  
there are methods that do what you are talking about but pure clustering of sql works with shared storage.. –  tony roth Jun 13 '12 at 13:55
    
Oh so the database needs to be moved to an external storage solution? –  Tom Jun 13 '12 at 13:56
1  
it needs to be shared storage as in a iscsi or san based storage. –  tony roth Jun 13 '12 at 14:56
1  
you probably don't need clustering use log shipping or mirror, this I think requires the enterprise version of sql. –  tony roth Jun 13 '12 at 14:58

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.