Re: [Bacula-users] Selecting jobids for restores

[Bill Arlofski via Bacula-users]

On 7/19/25 10:11 AM, Michel Figgins wrote:

Hello,





Thanks,

I have backups going to 2 different SDs – one local and one remote.  I’m attempting a full restore of a client which has Full, Diff, and Inc jobs.  Does anyone know of a way to find the necessary jobids that use just one of the SDs?  When I do the restore and select last full for a client, the resulting list of jobids includes jobs from both storages (which is not a huge deal except the Full backup it’s choosing is from the remote storage which is significantly slower than the local one). As I’m asking the question I’m realizing that at some point when I’m past the current fire, I’m going to want to re-architect using Virtual Fulls and/or Copy jobs.

Hello Michel,

In bconsole, you can first find out your storageids for the Storages:

* sql
Enter SQL query: SELECT * FROM storage;

Note the StorageID for the storage you want.


* SELECT jobid, name, level, jobstatus FROM job WHERE writestorageid='xxxx' AND 
jobstatus='T' AND name='yyyy';


This will get you what you need I believe.

Then, in bconsole, do the restore based on the F (local storage), Inc1, Inc2, 
Inc3:

* restore jobid=x,y,z
You have selected the following JobIds: x,y,z



Personally, I have not tried such a feat, so ymmv. :)

But, having said that, I re-read your message... It seems you are not yet using 
Virtual Fulls.



Can you describe your configuration a bit more?


Best regards,
Bill

--
Bill Arlofski
w...@protonmail.com

This assumes that when you ran the Virtual full, to the remote storage that you did not prune/purge the local Full and consolidated Diffs and Incs. Now I do not understand. If your fulls go to a remote storage, then that is the only place the full can be restored from. If you run the same job and it writes a Full to local and a full to remote at different times, "restore, option 6" or option12 might help.

signature.asc
Description: OpenPGP digital signature

_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users