Re: [Bacula-users] get the size of all backup jobs for client
Hello Daniel, Maybe an SQL query could help: select client.name, sum(job.jobbytes) from job, client where job.clientid=client.clientid and client.name='client1' and job.endtime>date1 group by client.name; Best regards, Ana On Wed, Jun 15, 2016 at 6:41 PM, Daniel <5960...@gmail.com> wrote: > Hello everyone > > I was wondering how to get the size of all backup files for client1 > since date1. > > > > -- > What NetFlow Analyzer can do for you? Monitors network bandwidth and > traffic > patterns at an interface-level. Reveals which users, apps, and protocols > are > consuming the most bandwidth. Provides multi-vendor support for NetFlow, > J-Flow, sFlow and other flows. Make informed decisions using capacity > planning > reports. > http://pubads.g.doubleclick.net/gampad/clk?id=1444514421=/41014381 > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Files pruned from catalog or never inserted - For one or more of the JobIds selected, no files were found, so file selection is not possible.
Hello Marcio,
Which was the version immediately previous to the upgrade to 7.05? In some
cases, there is a need of database upgrade.
Fortunately, there are ways to restore individual files by the use of bls
and bextract utilities.
With bls you can have a list of all the files backed up in one volume, the
you can use bextract with "-i" option and inform here a list of files to be
restored.
Also, you can use bscan to recover the jobs and media information from your
volumes into your catalog again.
Best regards,
Ana
On Thu, Jun 16, 2016 at 8:00 PM, Marcio Vogel Merlone dos Santos <
marcio.merl...@a1.ind.br> wrote:
> Hi,
>
> I am running a bacula server for years now, it has been upgraded since its
> 2.x version and now I got it to 7.0.5+dfsg-4build1 on a Ubuntu server 16.04
> with a postgresql database.
>
> Since its upgrade to 7.x I could not yet test a restore (shame on me, I
> know), and now a user asked for some yesterday's files. Guess what: "For
> one or more of the JobIds selected, no files were found, so file selection
> is not possible.". That happens to all clients and filesets.
>
> I searched Google and found some old and recent messages regarding this
> situation and none seems to apply to this case. Some info:
>
> Client {
> Name= orion-fd
> Address = 10.0.0.1
> FDPort = 9102
> Catalog = CatalogoA1Sede
> Password= "aaa"
> *File Retention = 6 months*
> Job Retention = 1 year
> AutoPrune = yes
> Maximum Concurrent Jobs = 1
> }
>
> Last full job for this client was on 2016-06-01, so much less than 6
> months. Yesterday's INC was like this:
>
> 15-Jun 22:17 phobos-dir JobId 39191: Start Backup JobId 39191,
> Job=JobOrionFab.2016-06-15_22.00.01_35
> 15-Jun 22:17 phobos-dir JobId 39191: Using Device "LTO" to write.
> 15-Jun 22:22 phobos-sd JobId 39191: Elapsed time=00:04:50, Transfer
> rate=52.40 M Bytes/second
> 15-Jun 22:22 phobos-dir JobId 39191: Bacula phobos-dir 7.0.5 (28Jul14):
> Build OS: x86_64-pc-linux-gnu ubuntu 16.04
> JobId: 39191
> Job:JobOrionFab.2016-06-15_22.00.01_35
> Backup Level: Incremental, since=2016-06-14 22:18:51
> Client: "orion-fd" 5.2.5 (26Jan12)
> x86_64-pc-linux-gnu,ubuntu,12.04
> FileSet:"FAB" 2016-01-04 15:27:59
> Pool: "PoolDiarioSemanal" (From Run Pool override)
> Catalog:"CatalogoA1Sede" (From Client resource)
> Storage:"LTO" (From Pool resource)
> Scheduled time: 15-Jun-2016 22:00:01
> Start time: 15-Jun-2016 22:17:30
> End time: 15-Jun-2016 22:22:21
> Elapsed time: 4 mins 51 secs
> Priority: 10 FD Files Written: 1,314
> SD Files Written: 1,314
> FD Bytes Written: 15,197,809,897 (15.19 GB)
> SD Bytes Written: 15,198,047,213 (15.19 GB)
> Rate: 52226.2 KB/s
> Software Compression: None
> VSS:no
> Encryption: no
> Accurate: no
> Volume name(s): PDS-0002
> Volume Session Id: 90
> Volume Session Time:1465823891
> Last Volume Bytes: 1,086,222,670,848 (1.086 TB)
> Non-fatal FD errors:0
> SD Errors: 0
> FD termination status: OK
> SD termination status: OK
> Termination:Backup OK
>
> 15-Jun 22:22 phobos-dir JobId 39191: Begin pruning Jobs older than 1 year .
> 15-Jun 22:22 phobos-dir JobId 39191: No Jobs found to prune.
> 15-Jun 22:22 phobos-dir JobId 39191: Begin pruning Files.
> 15-Jun 22:22 phobos-dir JobId 39191: No Files found to prune.
> 15-Jun 22:22 phobos-dir JobId 39191: End auto prune.
>
> No files or jobs were pruned, looks good.
>
> As per this thread
> http://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg41594.html
> I run those queries on db:
>
> select jobfiles from job where jobid=39191;
> Result: 1314, which matches "SD Files Written" above. Alas:
>
> select count(*) from file where jobid=39191;
> Result: 0
>
> When upgraded from 5.x to 7.x I had to add the "Maximum Concurrent Jobs"
> directive to all client and job defs otherwise it would wait for max
> something. Perhaps I missed something else? Has the file records been
> pruned from db or never been there?
>
> While dbcheck runs, can anybody kindly help me find what's wrong or what
> happened?
>
> Dir conf:
> #
> Director {
> Name = phobos-dir
> DIRport= 9101# where we listen for UA
> connections
> QueryFile = "/etc/bacula/scripts/query.sql"
> WorkingDirectory = "/var/lib/bacula"
> PidDirectory = "/var/run/bacula"
> Maximum Concurrent Jobs = 2
> Password = "aaa" # Console password
> Messages = Daemon
> # DirAddress = 10.0.0.2
>
Re: [Bacula-users] [Questions about Bacular Backup solution]
Hello Yeena, On Mon, Jun 27, 2016 at 8:00 AM, Yang, Yee Na (KR - Seoul) < yey...@deloitte.com> wrote: > Hi This is Yeena Yang. > > I was wondering if you could be answering my questions about the ‘Bacular > ’’ (open source) backup solution. > > Here are my few questions below. > > > > 1) Does it support Full image/Incremental/Differential backup? > Bacula supports Full/Incremental/Differential backups. Could you explain better what does mean "Full Image"? Are you talking about disk images? > 2) Does it support Online backup? > Do you mean backup on cloud? Currently there is no specific driver/implementation for this, but Bacula is easily configurable to backup in any mount point. With Bacula Open Source it is possible to backup in Amazon VTL and S3. > 3) Does it support Image and File restore? > There are specific plugins for this in the Enterprise version. > 4) Does it support Bare-metal restore? > Again, there is a plugin in the Enterprise version. > 5) Does it have a feature that * adjusting the band width when > backing up the network*? > yes. There are a few options to adjust the bandwidth on the client side, for a job, etc. > 6) Does it capable of “limiting the Hardware(e.g. Logical Unit > Number, HW layout etc)? > Could you please give more details about this? You can backup any filesystem/mountpoint with Bacula. > > > > > Thank you very much in advance. > > Best regards, > > Yeena > Best regards, Ana > > Deloitte refers to one or more of Deloitte Touche Tohmatsu Limited, a UK > private company limited by guarantee, and its network of member firms, each > of which is a legally separate and independent entity. Please see > www.deloitte.com/kr/about for a detailed description of the legal > structure of Deloitte Touche Tohmatsu Limited and its member firms. This > message (including any attachments) contains confidential information > intended for a specific individual and purpose, and is protected by law. If > you are not the intended recipient, you should delete this message and are > hereby notified that any disclosure, copying, or distribution of this > message, or the taking of any action based on it, is strictly prohibited. > > > -- > Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San > Francisco, CA to explore cutting-edge tech and listen to tech luminaries > present their vision of the future. This family event has something for > everyone, including kids. Get more information and register today. > http://sdm.link/attshape > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > > -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] [Questions about Bacular Backup solution]
Hi This is Yeena Yang. I was wondering if you could be answering my questions about the 'Bacular'' (open source) backup solution. Here are my few questions below. 1) Does it support Full image/Incremental/Differential backup? 2) Does it support Online backup? 3) Does it support Image and File restore? 4) Does it support Bare-metal restore? 5) Does it have a feature that adjusting the band width when backing up the network? 6) Does it capable of "limiting the Hardware(e.g. Logical Unit Number, HW layout etc)? Thank you very much in advance. Best regards, Yeena Deloitte refers to one or more of Deloitte Touche Tohmatsu Limited, a UK private company limited by guarantee, and its network of member firms, each of which is a legally separate and independent entity. Please see www.deloitte.com/kr/about for a detailed description of the legal structure of Deloitte Touche Tohmatsu Limited and its member firms. This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
