We help IT Professionals succeed at work.
Get Started

Zip/Compress SQL Backup on Windows 2008R2 server

2,057 Views
Last Modified: 2012-08-13
I am trying to determine the best/quickest way to backup, zip and move a SQL database backup file across a network.  

I'm trying to copy a large file across the network.  I would like to speed it up by compressing it or speeding it up some other way.

The source system is using Windows Server 2008R2 and SQL Server 2008 Standard Edition.  The destination system is using Windows Server 2008R2 and SQL Server 2008R2 but I will be moving to SQL 2012 Standard Edition in the next few weeks.

Specifically, I want to copy the .BAK file (already backup using a SQL agent job), zip/compress that file, copy it across the network (a VPN) to the destination server and unzip it.  Currently the db.bak file is about 16 GB, but it will grow.  I'm wondering if Windows Server 2008R2 has a way to zip a file that large or if powershell can?  I don't know the first thing about powershell.  I tried this a long time ago and as I recall the server I was using at the time could not handle a (zip) file that large.  Or, do I have to use something like WinRAR?  It is important that I automate the process.  I don't want to do it manually each day (or weekend).

Thanks for your help and ideas.
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE