John Drescher wrote:
> On 5/17/07, Paul Waldo <[EMAIL PROTECTED]> wrote:
>> Hi all,
>>
>> I have been backing up a file server with Bacula for a year or so. The
>> server has died and I am trying to restore the files to another machine
>> and not having much luck.
>>
>> Using the "restore" command from bconsole on the new box is not giving
>> me a warm fuzzy feeling. If I select Most Recent Backup, the number of
>> files selected is nowhere near large enough. It shows about 5,000
>> files, when I expect the number to be 10 times that.
>>
> Run the query command in bconsole and select "List all backups for a
> Client".
>
> Does the list look correct?
>
> If so you can restore individual jobs.
>
> John
>
Thanks for the reply, John. Unfortunately, this does not work for me.
As you can see from the transcript below, bacula thinks there are no
files in the jobs. Does this sound like the database is out of sync?
Thanks!
Paul
Connecting to Director backup.waldo.home:9101
1000 OK: backup-dir Version: 1.36.3 (22 April 2005)
Enter a period to cancel a command.
*query
Using default Catalog name=MyCatalog DB=bacula
Available queries:
1: List up to 20 places where a File is saved regardless of the
directory
2: List where the most recent copies of a file are saved
3: List last 20 Full Backups for a Client
4: List all backups for a Client after a specified time
5: List all backups for a Client
6: List Volume Attributes for a selected Volume
7: List Volumes used by selected JobId
8: List Volumes to Restore All Files
9: List Pool Attributes for a selected Pool
10: List total files/bytes by Job
11: List total files/bytes by Volume
12: List Files for a selected JobId
13: List Jobs stored in a selected MediaId
14: List Jobs stored for a given Volume name
15: List Volumes Bacula thinks are in changer
16: List Volumes likely to need replacement from age or errors
Choose a query (1-16): 5
Enter Client Name: paul-fd
+-------+---------+----------+-------+---------------------+----------+--------------+------------+
| JobId | Client | FileSet | Level | StartTime | JobFiles |
JobBytes | VolumeName |
+-------+---------+----------+-------+---------------------+----------+--------------+------------+
| 6 | paul-fd | Full Set | F | 2007-02-08 23:18:13 | 539512 |
180307676088 | PaulFull-1 |
| 102 | paul-fd | Full Set | F | 2007-03-04 23:05:02 | 515268 |
172884924198 | PaulFull-2 |
| 214 | paul-fd | Full Set | F | 2007-04-01 23:05:02 | 518328 |
174147800422 | PaulFull-3 |
| 218 | paul-fd | Full Set | D | 2007-04-15 23:05:02 | 4946 |
5309767278 | PaulDiff-3 |
| 246 | paul-fd | Full Set | D | 2007-04-22 23:05:02 | 5586 |
5278054959 | PaulDiff-4 |
| 274 | paul-fd | Full Set | D | 2007-04-29 23:05:03 | 6258 |
6916544070 | PaulDiff-1 |
| 347 | paul-fd | Full Set | I | 2007-05-16 23:05:02 | 2972 |
451312941 | PaulInc-3 |
| 347 | paul-fd | Full Set | I | 2007-05-16 23:05:02 | 2972 |
451312941 | PaulInc-1 |
+-------+---------+----------+-------+---------------------+----------+--------------+------------+
*restore
First you select one or more JobIds that contain files
to be restored. You will be presented several methods
of specifying the JobIds. Then you will be allowed to
select which files from those JobIds are to be restored.
To select the JobIds, you have the following choices:
1: List last 20 Jobs run
2: List Jobs where a given File is saved
3: Enter list of comma separated JobIds to select
4: Enter SQL list command
5: Select the most recent backup for a client
6: Select backup for a client before a specified time
7: Enter a list of files to restore
8: Enter a list of files to restore before a specified time
9: Cancel
Select item: (1-9): 3
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.
You are now entering file selection mode where you add (mark) and
remove (unmark) files to be restored. No files are initially added, unless
you used the "all" keyword on the command line.
Enter "done" to leave this mode.
cwd is: /
$ ls
$
-------------------------------------------------------------------------
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
