> 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 the idea of piping the generated 
dump file directly through the compressor:

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

I assume you used 'somecommand' because you don't know what/if there is a tool 
to dump a MSSQL database to STDOUT.  But isn't that question more appropriate 
for a MSSQL forum than a Bacula forum?

- Cedric

P.S. If you get that far, the "pipe" symbol is "|", not ">".




------------------------------------------------------------------------------
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