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.
Steve Hall
shared this idea
-
Friedrich Eberharter
commented
I am really wondering, why there is a feature to read compressed backups and if you try it on the standard compression of SQL Server it only says "this compression is not supported".
That would be very important to make partial restores like the OP points out and to have an efficient way to deal with the day-to-day tasks, because bis DBs cannot be handled without compression and so you always have to import them somewhere. -
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.