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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
