I know this seems like a trivial question and I have seen various explanations provided on the web, but they mostly seem pretty vague, so I would appreciate if someone could clear a couple of things for me:
- Each farm always has a single SharePoint configuration database, correct? In other words, as soon as you have multiple config databases, you have multiple farms?
- Is it correct to say that a single farm can comprise multiple Windows Servers (i.e. you install SP to multiple Windows Servers), but in the background they will all "point" to the same configuration database (meaning the same SQL Server instance is used to store configuration)?
- If I understand correctly, a single farm can comprise several Windows Server machines and several SQL Server machines as well - but this being a single farm, only one of the SQL Server instances will store the configuration database, while others can only store content databases?