1

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

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? – SPdev Jun 13 at 4:32

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.