When will we be able to compare compressed backups from SQL Server 2012 or later?

DBA_Merritt

After attempting to use a SQL Server 2016 compressed backup as a source in a SQL Compare project today I received an error stating "...uses a compression format that is not supported.".

I then found in the Redgate documentation that using a SQL Server Native Backup that has compression is not supported in SQL Server 2012 or later. 


https://documentation.red-gate.com/sc13/working-with-other-data-sources/working-with-backups

Is this planned on being fixed? If so, is there a date it should be delivered?

This feature of using compressed backups as a compare source isn't really useful when it only works with versions of SQL Server that are End of Life or are in Extended Support and about to become End of Life.

Alex B

Hi @DBA_Merritt,

Unfortunately, there are no plans to support compressed native backups from later version of SQL Server  in the near to medium term. A reference to this forum post has been added to the internal issue SC-6945 to 

Kind regards,
Alex