5

Is it a good practice to have 2 SQL Severs for a SharePoint site? If yes, can you recommend me link(s) for how to add it?

  • are you talking about 2 sql server in a farm or one site collection n mutliple db? – Waqas Sarwar MVP May 8 '15 at 17:55
  • Waqas Sarwar, thanks for your answer. Sorry that my question wasn't clear. 2 SQL Servers in a farm. Not planing to split the Content DB. – Kalai May 8 '15 at 20:48
  • yes it is supported, you can have more than 1 sql server in your farm. check my answer. – Waqas Sarwar MVP May 8 '15 at 21:06
7

If you want to split your site collection into multiple Content DB and then spread those DB across both SQL server. then it is Big NO

You can not have a site collection in to Multiple database, it is not supported.

If you want multiple SQL server attached to a farm, then you can do it. It is supported. we have 4 SQL server attach to one farm due to content. Usually customer split between content and services & config dbs. If you have high traffic sites on single sql server which will cause you performance issue, then adding another SQL server is best option.

To configure the 2nd Server for the content, you dont need to perform anything special just main requirement

A nice article: SharePoint with more than one SQL instance: possible or not possible

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.