How about backup with init + zip in One Step?

[DLu]

For a daily backup job,

Is there a way to "Backup Datbase dbXYZ to backup_dbXYZ with init", go, then next statment of master..xp_cmdshell to zip the backup_dbXYZ.bak to backup_dbXYZ.zip file?

Also, this may need to be done via remote server..

thanks
David

[skhanal]

You can create two step job to do just that.

Did you run into any issues?

[MAK]

why cant you try sqlzip

www.sqlzip.com

[skhanal]

I have read good review for this one too.

SQL LiteSpeed.

http://www.dbassociatesit.com/

[MAK]

Cool.
It handles YUKON too.
I need to evaluate this.

Thanks for the info pal.

[DLu]

thanks for the info.
But I have around 50 MSDE servers, if each require a license of SQLZip, the cost will be $500*50, not like feasible.
Thus, may still go to the second step by using free winzip to do so...

is anyone familiar with the winzip code with at least one parameter pass into?

[skhanal]

You can try gzip.exe

http://www.gzip.org/

This is a command line utility, so you can call it after your backup is finished.

[MAK]

http://www.pkware.com/

[MAK]

I hope next version (YUKON) has this compressing feature built in. It will useful for all the VLDBs we have.