Re: [Bacula-users] backing up databases - mysql mssql

2009-10-30 Thread Cedric Tefft
> 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 > In your original post, you proposed

Re: [Bacula-users] backing up databases - mysql mssql

2009-10-30 Thread Lukasz Szybalski
On Thu, Oct 29, 2009 at 6:27 PM, James Harper 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

Re: [Bacula-users] backing up databases - mysql mssql

2009-10-29 Thread James Harper
> 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. (uncomp

[Bacula-users] backing up databases - mysql mssql

2009-10-29 Thread Lukasz Szybalski
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