What are the challenges you face when working across database platforms? Take the survey

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

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. 


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.


  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    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,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.