Automated Backup and compress database

[nazarianazad]

Hi, How can daily Backup a database and compress it with win zip
yours sincerely
Iraj Nazarian Azad

http://www.ahra.ir

 

[bborissov]

You could create a SSIS package to do the backup and to compress created backup. Then you could add a JOB in SQL Server that will run this package.


Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[simian336]

You could do it from a job like you normally would then just add a task to the job to compress it with a command line based zip tool like 7zip.

Simi