Native Backups and Compression

  • I'm taking native backups using compression. However, I have a utility that is not compatible with native compressed or encrypted backups. Is there a way to take an existing compressed backup and decompress it for when I need to use the utility?

  • SQL Server will automatically uncompress the files. This is to ensure compatability.

  • SQL Server won't be doing the decompressing. I'm trying to use a third party utility that needs the backups to be decompressed.

  • AFAIK, no utility exists. SQL Server is designed to just do this. Most third party vendors, like Redgate with SQL Backup, do provide a utility so SQL Server can read the file, but since SQL Server can read compressed or uncompressed backups, I don't believe they built anything to uncompress a backup file.

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply