Hi all,
I'm looking for some ideas about how to create a Restore job such that a
random file, from a random client, from a random backup (which has not been
pruned, obviously) will be picked to be restored. I have been just
arbitrarily choosing a file to restore, but it will never be even close to
random, and isn't really a great way to test the backups.
Someone on the IRC channel got me started with the following query:
select * from File order by RAND() limit 1
This just gives me the FileId, and I would need to join with another table
to get the file name and which client it belongs to. But is there a better
way to approach this?
Also, I would like to be able to schedule this restore to happen once per
week. Is that possible?
Thanks so much for your time,
Misty
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
