Read from SQL Native Compressed Backups
Compare does not read from SQL backups that have used the native compression, although they can read from Redgate Backup files that have been compressed. I think that it should also be able to read from SQL compressed backups, as not all users will have Redgate Backup software.
This would be beneficial to all, because it would create a way of restoring lost data without using a partial restore, to any user that has this Compare software.
-
Seth Buxton commented
Thank you, Red Gate, for your quick action on this simple request. It is amazing how the update to your software allowed me to compare SQL Server 2012-to-present compressed, native SQL Server backups. It was only wee but a decade since SQL Server 2012 provided the option of compressed, native SQL Server backups. Red Gate seized the moment and quickly adapted to the 2022-surprise that, given an option to compress native SQL Server backups and conserve expensive disk space, savvy DBAs would utilize this feature of SQL Server 2012 and beyond.
Well-played, Red Gate, well-played!
-
Allan Boyd commented
without the ability to compare using a natively compressed backup, the functionality is essentially useless.