Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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 create a two node cluster using two basic network servers that only have local disks?

One will act as an idle standby server. Without knowing too much about clustering I'm not sure if a separate shared disk array is required.

If so, is it possible to use a DAS setup, or does it have to be a SAN that supports clustering?

share|improve this question

migrated from Aug 22 '12 at 5:02

This question came from our site for professional and enthusiast programmers.

I am afraid that this is not possible. Clustering works on the basis of resource ownership and acquisition; so anything that is not accessible to all nodes in the cluster cannot be used.

If shared storage is not an option for you then have a look at using mirroring which does not require storage to be shared across multiple servers. You could even use a witness server to automatically fail over should the primary become unreachable for any reason:



I hope this helps you.

share|improve this answer
Can this be done with virtualization? Or perhaps iSCSI and a clustered file system (I don't anything about this kind of setup on Windows though) – Jack Douglas Aug 22 '12 at 9:56
Hi Jack, SQL Server only supports local disks for storing the tempdb on. iSCSI is supported but from my understanding of the above question this is not available to the OP. – Mr.Brownstone Aug 22 '12 at 10:54
Is that because he is not on 2012? – Jack Douglas Aug 22 '12 at 11:41
Yes. Mirroring is the best option pre-2012. 2012 AlwaysOn Availability Groups would also move toward a shared nothing cluster. – swasheck Sep 5 '12 at 21:12

This is sort of possible using the SQL 2012 AlwaysOn feature, which allows you to create a cluster between two nodes that do not share storage. The setup uses database mirroring behind the scenes to replicate the data to the remote nodes storage but I don't think automatic failover is possible, would have to be kicked off by a user or process.

share|improve this answer

No, it is not possible to create a SQL cluster as you have described it.

share|improve this answer
That was not part of the original question. He asked a very straightforward question, I gave a straighforward answer. – datagod Sep 6 '12 at 13:10

Not in 2008, but in SQL 2012 you don't need to have shared storage and it WILL perform automatic failover if configured, as well as seperating read and write load, offsite backups and automatic corruption detection and repair.

You only need to file structure (disk letters and folder locations to be identical on the servers) if your going to consider this... check out these links...

then use brent's great checklist (this also contains further links to important pre reqs that you MUST perform and test before installing AlwaysON :

the only showstopper may be, this is only available in enterprise edition...

share|improve this answer

Your Answer


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