I would like to be able to set a database size threshold that governs whether or not to split a database backup into multiple files. I manage a few hundred databases that range in size from a couple of MB to a couple of TB. Rather than to have to create and manage multiple backup jobs just to handle specific databases (and have to make changes as the databases grow), I would like to be able to set up a rule that determines whether or not to generate multiple backup files based on the size of the database. Furthermore, I would like to set it up so that the number of backup files that are created is determined by the size of the database.
I realize that I could probably write a powershell wrapper around the Red Gate command line to do this. But, hey, I'm a lazy DBA and I'm paying you for support, so I figure I'd ask you guys to do it for me.