Bacula-users

Re: [Bacula-users] How to set up large database backup

2008-11-25 06:04:32
Subject: Re: [Bacula-users] How to set up large database backup
From: James Cort <james.cort AT u4eatech DOT com>
To: David Jurke <David.Jurke AT tnzi DOT com>
Date: Tue, 25 Nov 2008 11:01:51 +0000
David Jurke wrote:
> 
> The method we’re using for now is to back up the database by copying it
> to disk on the backup server (via NFS), and then back that up to tape.
> Trouble is, this is handling the data twice, and is currently taking
> well over twelve hours all up, which given the expected growth is going
> to become untenable fairly soon, so any suggestions gratefully received!
> Not to mention we’re going to run out of disk space!!

You don't mention what OS or DBMS the database is, given the context I'm
assuming it's for some other business process than Bacula.

Does the SAN support snapshots?  You could always take a snapshot, back
it up and then remove the snapshot afterwards.  There may need to be
some scripting to make sure the database is in a consistent state before
you do this, but it'd be a lot quicker than copying the data.

-- 
James Cort

IT Manager
U4EA Technologies Ltd.

-- 
U4EA Technologies
http://www.u4eatech.com


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users