compress existing backup file?

Question

Post reply

compress existing backup file?

ericb1

SSCrazy

Points: 2354
More actions
January 22, 2015 at 2:55 pm

#294002

any help is appreciated, I have a SQL 2012 enterprise server, and I'm using Commvault as my backups. So commvault can restore a .bak file to my server, but it cannot use sql compression on the file apparently. So what would be a 150GB .bak backup file is now 600GB. I have to manually upload these files to an auditing firm on an sftp server and the transfer times are now huge.
Is there a way to use something in sql to compress this already existing .bak file down? sql command line or something? any help is appreciated, thanks!

Viewing 6 posts - 1 through 5 (of 5 total)

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

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 1

Windows has built-in ability to compress files. 7-z or others may have command line ability too.

You could stop using Comm Vault. Also, are you 100% certain it cannot use compressed backups?

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

ericb1 SSCrazy Points: 2354 More actions · Answer 2

Ok, thanks, is there a way to use windows (2012r2) to do it with a command-line? Just trying to automate it without having to install extra software on a production server.

And i did verify that with commvault tech support. Commvault is working well and is our enterprise backup solution and does all our backups and restores, this is just a one off restore i need to take off site

Thanks!

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 3

ericb1 (1/22/2015)
Ok, thanks, is there a way to use windows (2012r2) to do it with a command-line? Just trying to automate it without having to install extra software on a production server.
And i did verify that with commvault tech support. Commvault is working well and is our enterprise backup solution and does all our backups and restores, this is just a one off restore i need to take off site
Thanks!

Sorry, but Commvault cannot be said to be working well if it cannot use SQL Server backup compression.

I have no idea if you can do a command line zip of a file in Windows 2012 R2. But I am certain a little Binoogling can find the way for you. Powershell may well be involved.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Jeff Moden SSC Guru Points: 1003865 More actions · Answer 4

ericb1 (1/22/2015)
any help is appreciated, I have a SQL 2012 enterprise server, and I'm using Commvault as my backups. So commvault can restore a .bak file to my server, but it cannot use sql compression on the file apparently. So what would be a 150GB .bak backup file is now 600GB. I have to manually upload these files to an auditing firm on an sftp server and the transfer times are now huge.
Is there a way to use something in sql to compress this already existing .bak file down? sql command line or something? any help is appreciated, thanks!

Send a tape via FedEx. It will get there almost as quick (maybe quicker) and cost you a whole lot less. Either that or do a "Copy Only" backup with compression so as to not upset the backup chain on CommVault.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ericb1 SSCrazy Points: 2354 More actions · Answer 5

ok, thanks. And Commvault does work well, it's an enterprise solution that does back up and restores, replication, log shipping, deduplication, disaster recovery, etc., all perfectly across our environment. This is just a scenario outside the scope of what it can do since the backup has to go outside our environment.