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.