Holikar, Sachin (ext) wrote:
 > Hello,
 >
 > I agree if I rename just the file name in bacula-dir.conf , it will 
start to write in a new file.
 > But the point is the file which has grown in size is "bacula.sql".
 > So this is the actual file in question. Can we do something about 
this file?
 >

I understand - you ask about .bsr file

 >> 1>    Is there anyway we can move this (and other .bsr) files to
 >> someother location having large space without affecting Bacula
 >> functionality?
 >> 2>    Can we somehow reduce the size of this file? Compression ?


The bacula.sql, if I good remember, it's your main CatalgoDB - sqlite.

The best method is migration to Postgres or MySql.
My database size reduce from 400MB to 150MB when I've done it.
But if you don't want do it, just try to reduce your jobs retention.

There is another way - try to export import procedure.

# sqlite bacula.sql .dump > dump.sql              # dump
# sqlite new_bacula.sql < dump.sql                  # restore

sometimes you can reduce db size but no guarantee






-- 
=========================
Damian

------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users