If you set it to, yes.
My backup (configured via the Backup manager) will store all sites and databases. But this is something you will need to enable and configure before you can take advantage of it.