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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply