Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

share|improve this question
1  
This question appears to be off-topic and better be posted here dba.stackexchange.com instead –  Muhammad Raja Jan 2 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 MCSA Jan 2 at 13:44
    
@BennySkogberg thanks for letting me know, retracted my closing vote. –  Muhammad Raja Jan 2 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 MCSA Jan 2 at 14:04

1 Answer 1

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.

share|improve this answer
    
@MuhammadRaja thanks for letting me know about the dba site, didn't about that. –  CodigoNinja Jan 2 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. –  CodigoNinja Jan 2 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. –  Anders Rask Jan 3 at 8:47

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.