Re: resetting database
Arno Lehmann via Bacula-users <[email protected]>
| Newsgroups | gmane.comp.bacula.user |
|---|---|
| Organization | IT-Service Arno Lehmann |
| Message-ID | <[email protected]> |
Hi Alan, Am 26.11.2025 um 15:12 schrieb Alan Polinsky: > My version of Bacula, 9.6.7 have been running on my Slackware box for > quite awhile. Unfortunately, in the past year I've had some electrical > work done that has stopped various backups mid stream. When that has > happened, the volume in progress has marked the VolStatus as 'Disabled'. > In order to re-use those volumes, I have used SQL to mark them as > 'Recycle'. Is there a way to synchronize the MariaDb tables with the > current contents of all media? My storage device is LTO3. Tricky. If you're lucky, you can still find the jobs on those volumes in the catalog, and then you should just purge the volume, or delete the jobs using the respective bconsole commands. In general, manually modifying the catalog is something you should be careful with. In your case, the (in my opinion) most useful approach would have been to set the volumes in question to "Append" or "Used" state, keeping the incomplete jobs (an incomplete job may be better than none) or deleting the affected jobs (if in incomplete job is pointless). In the latter case, the volumes once put into an enabled state would be eligible for regular recycling. All that said, if you can afford the temporarily wasted space, just enable the volumes in question again and let them be touched by regular recycling. If you kind of want to "revive" the volume contents even after it's removed from the catalog, first set the volumes into "Used" state, stop the SD in question, if possible make sure the DIR does not do anything, and use bscan on the volumes. A catalog dump beforehand is advised. All that said, if I missed what you really want to achieve, please give some more detail ;-) Cheers, Arno > Thank you. > > > Alan > > > > _______________________________________________ > Bacula-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Arno Lehmann IT-Service Lehmann Sandstr. 6, 49080 Osnabrück _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users