Phil Stracchino a écrit : > 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. > >
Well it's more or less that, except that there is ~200 db per server, and 4 db server (for now). I had though of this setup, but it wanted to do the same 'in live' using a fifo so that i don't have to store db on files. Anyway i think i will use that way, i will be easier. Thanks (Still if someone know it's doable using fifo i'm interested) benoit ------------------------------------------------------- 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
