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 →