Is it possible to have same web application with two site collections having content databases in two different SQL servers?

If so, can farm back and restore method from CA be used for restoration?

1 Answer 1


you can have multiple database across multiple SQL server for the same web applications. I have same kind of requirement and working without any issue.

Yes farm backup and restore method will work as well, because when you perform the restore it will ask you where to restore. at that time you can tell the sql instance name.

  • thanks for the answer, my doubt while restoring from CA is, it normally asks for one SQL instance name against a web application, so once we configure this set up will it ask for 2 SQL server instance name against a single web application?
    – SP2013dev
    Jun 13, 2019 at 4:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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