Thanks James, Sorry, missed that bit... Oracle on Linux. The database is, as you say, for the business, hence the need to back it up!
And sadly no, our SAN doesn't support snapshots, or for sure I'd have been doing that! Likewise I don't have the option of breaking RAID mirrors and doing it that way. Cheers, David. -----Original Message----- From: James Cort [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 November 2008 00:02 To: David Jurke Cc: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] How to set up large database backup 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
