Hello,

I'm trying to backup the mysql and mssql databases to a file and then
let bacula backup the actual folder where my files are stored.

For mysql it was fairly simple. I created a script that mysqldump the
whole database into a gz file every day. There is also a line in there
to remove backup today - 14 days. That way incremental bacula backups
will be backing up only the new daily backup, and I will have access
to quick backup for last 14 days. (rest should be in bacula)

Here is the script:
http://lucasmanual.com/mywiki/Bacula#Mysql


Now I need to backup mssql, I tried using its tool but the backup file
is too big and I can't fit two backups into a harddrive. (uncompressed
200gb) (gz 2GB). I would like to setup a script that will start
backing up the mssql database and pipe that through a gz program (7zip
in windows 2000 for example) so that there is no intermediate step.


somecommand backup all > 7z.exe outputfile.gz ??

Is that possible. Would anybody have a script ready that they use? Can
full, and differential backup be done with it?

Thanks,
Lucas



-- 
Setup CalendarServer for your company.
http://lucasmanual.com/mywiki/CalendarServer
Automotive Recall Database - See if you vehicle has a recall
http://lucasmanual.com/recall

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users