January 22, 2015 at 2:55 pm
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!
January 22, 2015 at 3:34 pm
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
January 22, 2015 at 6:00 pm
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!
January 22, 2015 at 6:51 pm
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
January 22, 2015 at 8:15 pm
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
Change is inevitable... Change for the better is not.
January 23, 2015 at 7:46 am
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.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy