We use RedGate backup tool for our sql server database backups. Have couple of questions:
1. I split the backup into multiple files. Is there a way to combine those multiple backup files into just 1 file later? I have 20 sqb files for the same database backup - how to combine them into just 1 sqb file if needed?
2. Currently, I have to specify how many files I need the backup to be split into, and I have to give the file names. But I want the number of files to be dependent on the backup size. That is if the backup size is 10gb, then split it into 20 files, if it is 15gb, then 30 files - something like that. In a way, I want the backup file size to be fixed, say at 500mb. Is it possible? Also, can I just specify a naming convention for the backup files instead of specifying all the file names literally?