On Thursday 2017-03-16 15:31:37 Kern Sibbald wrote:
> Hello,
> 
> I recently took a look at my catalog a bit more in detail when an
> upgrade of my backup server from 14.04 to 16.04 failed (I have 6
> systems where the upgrade totally failed and left me with a broken
> system), and so I reloaded the Bacula catalog from scratch and in doing
> so I realized that there were lots and lots of old records in it from
> jobs that I had run several years ago.  This happens when you create a
> job or a client, then stop using that job or client (or even remove the
> client) so that no more jobs for that client run.  What is important is
> that Bacula prunes only when a job runs unless you do it manually, and
> if jobs never run, the retention periods never apply and you end up
> with lots and lots of unused (orphaned) records in the catalog.  The
> only way to clean it up is to see what jobs exist in the database and
> prune/purge those which are no longer used -- this is done manual with
> bconsole.

I believe that dbcheck can be used to clean the orphaned records.

-- 
Josip Deanovic

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users