You can use either database depending on the number of clients you want to build the environment for. So you can use embedded databases for each of the SEPM (Main & Backup) seperate and set them up as a replication pair.
Or for larger clients base you can either setup one SQL instance and have both SEPM share the SQL database or if you have an extra SQL server each can have their own and replication setup between them.