Hello,
On 5/18/2007 6:00 PM, Paul Waldo wrote:
> John Drescher wrote:
>> On 5/18/07, Paul Waldo <[EMAIL PROTECTED]> wrote:
>>> Troy Daniels wrote:
>>>> Hope this isn't redundant, but have you tried doing a restore of
>>> job 214?
>>>> That appears to be your most recent full backup according to the table
>>>> below. Hopefully it's file records haven't been cleaned from the
>>>> database.
>>>>
>>>> After that I believe you'd just need to restore jobs 274 (Most recent
>>>> diff) and 347 to bring it up to the state it was in on the 16th.
>>>>
>>>> Cheers,
>>>>
>>>>
>>>> Troy
>>> Thanks for the reply, Troy. It looks like the records from job 214 have
>>> been cleaned. Selecting that job for restore reports 0 files :-(
>>>
>>> Paul
>>>
>> Have you tried restoring a job even though it reports no files
>> selected? If that does not work I believe you can still use bscan to
>> rebuild the catalog.
>>
>> John
>>
> Ugh, no dice:
> Enter JobId(s), comma separated, to restore: 6
> You have selected the following JobId: 6
>
> Building directory tree for JobId 6 ...
> 1 Job, 0 files inserted into the tree.
I haven't fllowed this discussion in detail, but the following is an
excerpt from the manual, restore chapther:
"Problem
I try to restore the last known good full backup by specifying item
3 on the restore menu then the JobId to restore. Bacula then reports:
1 Job 0 Files
and restores nothing.
Solution
Most likely the File records were pruned from the database either
due to the File Retention period expiring or by explicitly purging the
Job. By using the "llist jobid=nn" command, you can obtain all the
important information about the job:
llist jobid=120
JobId: 120
Job: save.2005-12-05_18.27.33
Job.Name: save
PurgedFiles: 0
Type: B
Level: F
Job.ClientId: 1
Client.Name: Rufus
JobStatus: T
SchedTime: 2005-12-05 18:27:32
StartTime: 2005-12-05 18:27:35
EndTime: 2005-12-05 18:27:37
JobTDate: 1133803657
VolSessionId: 1
VolSessionTime: 1133803624
JobFiles: 236
JobErrors: 0
JobMissingFiles: 0
Job.PoolId: 4
Pool.Name: Full
Job.FileSetId: 1
FileSet.FileSet: BackupSet
Then you can find the Volume(s) used by doing:
sql
select VolumeName from JobMedia,Media where JobId=1 and
JobMedia.MediaId=Media.MediaId;
Finally, you can create a bootstrap file as described in the
previous problem above using this information.
If you are using Bacula version 1.38.0 or greater, when you select
item 3 from the menu and enter the JobId, it will ask you if you would
like to restore all the files in the job, and it will collect the above
information and write the bootstrap file for you. "
So, depending on your version of Bacula, things might be quite simple,
or you might have to create a bootstrap file manually (which is not
overly complicated).
...
> A fun added wrinkle is that the ubuntu dapper bacula packages don't
> contain bscan :-O
> They do have bextract which seems to be reading the older backups
> without problem. I figure I'll get the new file server to NFS export a
> directory, mount it from the backup server, and use bextract to write
> the files onto the mounted dir.
>
> Thanks to all for your help. I think I can breathe now :-)
Always good :-)
Good luck restoring!
Arno
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
