Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

Only Standard and Enterprise editions support clustering, and Standard only 2 nodes at that. Have a look at this matrix:

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

Your Answer


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.