IP <irekpias <at> op.pl> writes: > > Hi. > > I have done incremental backup. In Job report i can see, that 219 files > were written (FD and SD): > ... > FD Files Written: 219 > SD Files Written: 219 > FD Bytes Written: 5,818,250,517 (5.818 GB) > SD Bytes Written: 5,818,295,146 (5.818 GB) > > Then i make simple mysql query on bareos database: > > mysql> select count(*) from File where JobId=307; > +----------+ > | count(*) | > +----------+ > | 218 | > +----------+ > 1 row in set (0.00 sec) > > So - there is 218 files, one file is missing ? Or ? No on windows there is one so called "Restore Object" which contains the metadata of VSS. That is not in the file table but in a special other table and is restored before anything else when you restore that particular Job.
> > More. > > I made in bconsole: > > list files jobid=307 > > That gives mi list of 218 files. At the end there is: > ... > > But, when i want restore all files only from JobID 307 - in bconsole > selected option 3 when restore: > 3: Enter list of comma separated JobIds to select > > 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: Find the JobIds of the most recent backup for a client > 10: Find the JobIds for a backup for a client before a specified time > 11: Enter a list of directories to restore for found JobIds > 12: Select full restore to a specified Job date > 13: Cancel > Select item: (1-13): 3 First of all doing anything else the option 5 or 6 with accurate is asking for problems. Why do you want to extract exactly one incremental I guess the idea is that you either want to restore the latest or some specific time. Let the software determine what you need instead of being clever and restore bits and pieces which will never give you what you actually want. > Enter JobId(s), comma separated, to restore: 307 > You have selected the following JobId: 307 > > Building directory tree for JobId(s) 307 ... > ++++++++++++++++++++++++++++++++++ > 170 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: / > $ select * > Invalid command "select *". Enter "done" to exit. > $ mark * > 173 files marked. > > So why bareos shows me files 218 - 219(?), that wehere backed up, but i > can't restore all files from exactly this JobID. I expected to restore > all files from this job. Bareos inserts 170 files into the tree. > Accurate job is on. And that is probably also your problem, with accurate it can be very well it saved so called FT_DELETED entries e.g. and empty backup entry that describes that the file doesn't exist anymore in your backup. As those entries are place holders only and used by the accurate restore to only restore the exact status at a certain moment in time you should use the option 5 or 6 restore. -- Marco van Wieringen [email protected] Bareos GmbH & Co. KG Phone: +49-221-63069389 http://www.bareos.com Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 Komplementär: Bareos Verwaltungs-GmbH Geschäftsführer: Stephan Dühr, M. Außendorf, J. Steffens, P. Storz, M. v. Wieringen -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
