Can anyone please help me on installing sql server 2012 on cluster mode between two servers running windows 2012 server without external storage?

I will use the sql for sharepoint 2013 installation for a file server so the need of fault tolerance is big.

Thanks everyone

  • 1
    This question appears to be off-topic and better be posted here dba.stackexchange.com instead Jan 2 '14 at 11:50
  • @MuhammadRaja In the advanced certification of Sharepoint 2013 (70-332), 20% of the certification covers SQL Server, log shipping, clustering and mirroring. because of that I feel that this question could very well fit both on DBA.SE and here at SP.SE. No need to close this one as it stands.
    – Benny Skogberg
    Jan 2 '14 at 13:44
  • @BennySkogberg thanks for letting me know, retracted my closing vote. Jan 2 '14 at 13:55
  • @MuhammadRaja You're welcome. Nice of you to retract the close vote. I didn't know that could be done. We both learn from each other :-)
    – Benny Skogberg
    Jan 2 '14 at 14:04

If we are talking SharePoint 2013 and SQL Server 2012 you have the possibility of creating an AlwaysOn cluster for high availability.

I recommend starting with this blog post that will give you a step-by-step guide on how to set it up. Then proceed to read all available articles on TechNet on the subject. This include planning (especially focus on High Availability), install and configure & operate and maintain.

Read all the articles related to SQL before you start planning your approach, weather you need HA and what type of HA (AlwaysOn, Logshipping, Mirroring) and how you want to design your cluster.

  • @MuhammadRaja thanks for letting me know about the dba site, didn't about that. Jan 2 '14 at 14:43
  • but as this is a sharepoint forum and sql server is to run sp 13 so I thought could find help quicker, @AndersRask thanks for sharing the links, already reading them. Jan 2 '14 at 14:47
  • Definately some good help to be found in the DBA site also. Some stuff will be specific to SharePoint configuration-wize (eg. supported scenarios) but in general "good practices" for a fast performing SQL server (eg. RAID recommendations for tempdb, log files etc) works for a SharePoint farm as well. Jan 3 '14 at 8:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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