Benoit Plessis wrote:
>
> Hi,
>
> I need to backups many sql databases, located on differents servers but
> with at least 200 db/servers.
> So when restoring db most of the time it's only one db that need a restore.
>
> The question is: is it possible with a fifo backup to split data in
> directory/files record in the backup volume ?
> To be clear i want to be able to do a restore on the db archive and
> select a file using the interface, which
> contain the only table i need.
If I understand your question correctly:
You need to back up 200 or more SQL databases distributed across several
SQL servers, but you want to be able to restore databases individually.
Do I have that right?
If that's the case, I'd write a ClientRunBeforeJob script that dumps the
databases into separate dump files, then back up the directory of dump
files, then use a ClientRunAfterJob script to delete the dumps.
--
Phil Stracchino [EMAIL PROTECTED]
Renaissance Man, Unix generalist, Perl hacker
Mobile: 603-216-7037 Landline: 603-886-3518
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server.
Download it for free - -and be entered to win a 42" plasma tv or your very
own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
