Options
When will we be able to compare compressed backups from SQL Server 2012 or later?
DBA_Merritt
Posts: 2 New member
in SQL Compare
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.
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.
Tagged:
Comments
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
Have you visited our Help Center?