The first question that I have in mind before continuing this post is:
Q: Is it possible to have multiple instances for the same SharePoint farm?
A: Yes it is possible, we can have more than one SQL instance where we can store the content databases.
If you want to transfer a SharePoint content database from one instance to another you can use the following procedure:
Continue reading