I want SQL backup compression added to MABS
I want SQL backup compression added to MABS so that a restore of a database is quicker.
Built into the SQL application for years has been the ability to backup with compression (attached). MABS does not have this. Restoring the files to an alternate location takes 2x to 5x longer when uncompressed. We are currently not using MABS against these database files for this reason.
When creating a protection group in MABS, under "Select data protection method", we select both "I want short-term prtection using: Disk" and "I want online protection". There is no option to compress the database files. When restoring from disk to an alternate location, it's restoring bit for bit. So in a test restore we performed, the .mdf and .ldf files that are being restored bit for bit took 3.5 hours to complete. From our old system with those same files being compressed, it took ~1 hour.