June 25, 2019 at 5:39 pm
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?
June 25, 2019 at 5:45 pm
SQL Server will automatically uncompress the files. This is to ensure compatability.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 25, 2019 at 5:55 pm
SQL Server won't be doing the decompressing. I'm trying to use a third party utility that needs the backups to be decompressed.
June 25, 2019 at 6:10 pm
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply