title: SQL Server 2008 - how to zip backup files and move to remote server
body: <p>I have the non-enterprise edition of SQL Server 2008. I do nightly backups, manually zip the files and then manually copy to a remote server.</p>
  
  <p>I need to automate this using batch files. Copying files from server to server is easy but how do I automate the zipping of the backup first?</p>
  
  <p>The full process I need is:</p>
  
  <ol>
  <li>Run the backup nightly</li>
  <li>Zip the backup to reduce size (with a unique zip filename)</li>
  <li>Move the zip file to a remote server which is setup as a network drive on the database server</li>
  </ol>
  
  <p>I confess the compression part has thrown me off. Any advice would be very much welcomed.</p>
  
  <p>Thanks in advance.</p>