On Thu, Oct 29, 2009 at 6:27 PM, James Harper <james.har...@bendigoit.com.au> wrote: >> 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. >> >> ... >> >> 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? >> > > At this time the two options you have are: > > 1. Let VSS do its thing. This is _only_ reliable for a full backup. > Incremental and differential backups will not do what you expect - if > the .mdb file has changed since last backup it will be backed up, > otherwise it will not, and database updates do not always result in a > filesystem-visible change of the .mdb file. You also can't do point in > time restores etc using this method, only snapshot backups. > > 2. As you are already doing, back up the database and logs to files. If > you back up to a file and then back the file up using bacula then you > really don't need more than one backup on disk. If you want more, plug > in a USB disk and do the mssql backups to that. >
My biggest issues is the space usage. Right now I would have to backup 200GB to a file, then compress it to 2gb, delete the 200gb file. If you do that every day that is extremely heavy on hdd. Is there a better way for mssql? Thanks, Lucas ------------------------------------------------------------------------------ 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
