On 10/18/10 08:08, Damian Ge;bicki wrote:
> Phil Stracchino wrote:
>> On 10/18/10 07:21, Holikar, Sachin (ext) wrote:
>>
>> Well, without seeing the script, we're somewhat guessing. Personally, I
>> keep my catalog dumps around because if something crashes my database,
>> it's faster to just reload the last database than to do a bscan.
>> However, I'm currently working on moving to a snapshot-based backup
>> instead, in which I won't have a dump file at all, and will in fact
>> simply take filesystem snapshots for my incremental database backups and
>> keep the most recent snapshot around until the next night's backup has
>> been completed.
>
> Yes, but the only 100% way to recover from disaster (backup server) is 
> Catalog copy on dedicated media - tape media.

I think you misunderstand.  The snapshot replaces the dump, not the
backup.  Instead of dumping the databases and backing up the dump, the
idea is to quiesce the tables, snapshot the databases, and back up the
snapshot.  The object of the exercise is to reduce the time the tables
are locked (from minutes down to a couple of seconds).


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
         Renaissance Man, Unix ronin, Perl hacker, Free Stater
                 It's not the years, it's the mileage.

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