The same web application with db content on two separate database servers

Is it possible to have the same web application with two site collections that have content databases on two different SQL servers?

If so, can the CA recovery and restore method be used for the restoration?