The job should take the backup of a database and zip the backup file.

• charipg

  SSCrazy Eights

  Points: 9888

  More actions

  July 16, 2010 at 1:15 am

  #235324

  I need to create a job .

  The job should take the backup of a database and zip the backup file.

  please help on this.

• sumit.agrawal

  SSCommitted

  Points: 1616

  More actions

  July 16, 2010 at 1:38 am

  #1193915

  Configure Database Backup using Maintenance Plan and add another step to compress Backup File.

  Syntax to compress the backup file by using winzip :

  winzip32 [-min] action [options] filename[.zip] files