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.

Is it possible to run an SQL Server Web edition in a Windows 2008 R2 Failover Environment?

I want to host a Website with backend database but keep it failsave with a failover cluster (install it on two nodes and failover if one node fails).

share|improve this question
add comment

1 Answer

Only Standard and Enterprise editions support clustering, and Standard only 2 nodes at that. Have a look at this matrix: http://msdn.microsoft.com/en-us/library/cc645993(SQL.100).aspx

share|improve this answer
    
is there a way to do that manually? Like stopping services etc. Clustering something etc.? –  Uwe Sep 27 '11 at 11:04
    
You could simulate it with log shipping, where the fail over would be manual, and still you would lose the unshipped part of work (typically up to 15 minutes). –  Nienor Oct 2 '11 at 13:28
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.