Re: [Bacula-users] Best way to force a volume to recycle so it can be used immediately

2013-01-17 Thread Marcello Romani
Il 17/01/2013 21:36, Craig Isdahl ha scritto: > All - > > I goofed on a config change and have multiple copies of 20gb data > backups - I don't need all that so I'd like to recycle them immediately > rather than waiting for auto recycling to happen (90 days). All backups > are to disk volumes. Wha

Re: [Bacula-users] Catastrophic overflow block problems

2013-01-17 Thread Josh Fisher
On 1/17/2013 2:10 PM, Ruth Ivimey-Cook wrote: Josh Fisher wrote: You don't. I find it very strange that returning "device full" from a volume write can reasonably be interpreted as "device not quite full". The trick is to define a maximum volume size and number of volumes on the drive so that

Re: [Bacula-users] Best way to force a volume to recycle so it can be used immediately

2013-01-17 Thread Novosielski, Ryan
Any drawback to a purge right now? None I can think of if you don't need the data. Marking them used will respect the retention policy which it sounds like you don't want. From: Craig Isdahl [mailto:cr...@isdahl.com] Sent: Thursday, January 17, 2013 03:36 PM To: Bacula-users@lists.sourceforge.

[Bacula-users] Best way to force a volume to recycle so it can be used immediately

2013-01-17 Thread Craig Isdahl
All - I goofed on a config change and have multiple copies of 20gb data backups - I don't need all that so I'd like to recycle them immediately rather than waiting for auto recycling to happen (90 days). All backups are to disk volumes. What's the best way to do that? If I mark them 'used"

Re: [Bacula-users] Catastrophic overflow block problems

2013-01-17 Thread Dan Langille
On 2013-01-17 11:06, Ruth Ivimey-Cook wrote: > Hi, > > I am sometimes getting these errors in my bacula backups: > > Fatal error: device.c:192 Catastrophic error. Cannot write overflow > block to device "DiskStorage-drive-0" > and it is more likely on the larger volume backups. It seemingly > res

Re: [Bacula-users] bacula tape rotation

2013-01-17 Thread John Drescher
> I have one question abou backup plan. > > I have 500GB web partition I want to backup, I have IBM TS3200 Library and > two 800GB Tapes > > My plan is that Sunday at 2 a.m. I will make full backup and then every day > Incremental at 2.a.m at first tape. > Next Sunday I will make again full back

Re: [Bacula-users] Catastrophic overflow block problems

2013-01-17 Thread Josh Fisher
On 1/17/2013 11:06 AM, Ruth Ivimey-Cook wrote: Hi, I am sometimes getting these errors in my bacula backups: Fatal error: device.c:192 Catastrophic error. Cannot write overflow block to device "DiskStorage-drive-0" and it is more likely on the larger volume backups. It seemingly results from b

Re: [Bacula-users] Client side FS detection

2013-01-17 Thread Novosielski, Ryan
Please don't thread hijack. I imagine this is an accident, but it makes things very confusing when the content matches some other subject line. From: brconflict [mailto:brconfl...@gmail.com] Sent: Thursday, January 17, 2013 09:51 AM To: Florian Heigl Cc: bacula-users@lists.sourceforge.net Sub

[Bacula-users] Catastrophic overflow block problems

2013-01-17 Thread Ruth Ivimey-Cook
Hi, I am sometimes getting these errors in my bacula backups: Fatal error: device.c:192 Catastrophic error. Cannot write overflow block to device "DiskStorage-drive-0" and it is more likely on the larger volume backups. It seemingly results from bacula trying to write an additional block to a

Re: [Bacula-users] Client side FS detection

2013-01-17 Thread brconflict
So I managed a bare-metal restore, but still requires either static-bacula-fd or bacula-fd with library tools. Compiling bacula-fd withis --disable-libtool gives me a "No such file or directory", which indicates that there is a missing library. So, I know now that the issue I'm having is simply wi

Re: [Bacula-users] save DB's online

2013-01-17 Thread Uwe Schuerkamp
On Thu, Jan 17, 2013 at 08:52:32AM -0500, Phil Stracchino wrote: > On 01/17/13 08:33, Uwe Schuerkamp wrote: > > Could we expect to see better db performance by moving to innodb or > > one of MariaDB's fancy new backends? I'm especially interested in > > improving volume recycle times which can be q

Re: [Bacula-users] save DB's online

2013-01-17 Thread Phil Stracchino
On 01/17/13 08:33, Uwe Schuerkamp wrote: > Could we expect to see better db performance by moving to innodb or > one of MariaDB's fancy new backends? I'm especially interested in > improving volume recycle times which can be quite long with our setup > (200GB file table). the DELETE from File where

Re: [Bacula-users] Reporting on previous jobs

2013-01-17 Thread Jack Cobb
Bill, Thanks for the information. Using your ideas and with help from one of our MySQL programmers we were able to create a script that will work for us. Jack On 01/16/13 14:33, Jack Cobb wrote: > We are using Bacula 5.0.3 on an Ubuntu 10.04 server using MySQL as the > database engine. We r

[Bacula-users] bacula tape rotation

2013-01-17 Thread dubnik
Hi I have one question abou backup plan. I have 500GB web partition I want to backup, I have IBM TS3200 Library and two 800GB Tapes My plan is that Sunday at 2 a.m. I will make full backup and then every day Incremental at 2.a.m at first tape. Next Sunday I will make again full backup on nex

Re: [Bacula-users] save DB's online

2013-01-17 Thread Uwe Schuerkamp
On Thu, Jan 17, 2013 at 08:20:48AM -0500, Phil Stracchino wrote: > One last footnote: *SOLELY* setting MySQL read-only does NOT guarantee > a consistent backup. You must FLUSH TABLES, and even then you're still > not 100% safe on InnoDB. > Agreed, I forgot that important step in my previous ema

Re: [Bacula-users] save DB's online

2013-01-17 Thread Phil Stracchino
On 01/17/13 04:55, Uwe Schuerkamp wrote: > On Thu, Jan 17, 2013 at 10:40:26AM +0100, Sven Gehr wrote: >> Hi@all, >> >> is it possible to backu databases e.g. mysql, pgsql (on other hosts) >> with bacula online? > > > Yes and no. If there are no jobs running you can set the db to read > only, but

Re: [Bacula-users] Reporting on previous jobs

2013-01-17 Thread Jérôme Blion
Le 2013-01-16 20:33, Jack Cobb a écrit : > We are using Bacula 5.0.3 on an Ubuntu 10.04 server using MySQL as > the database engine. We review each day's backup to verify it > completed but now our auditors are asking for a report that shows the > backup job results for the previous twelve months..

Re: [Bacula-users] parallelizing ClientRunBeforeJobs

2013-01-17 Thread Dan Langille
On 2013-01-17 05:34, lst_ho...@kwsoft.de wrote: > Zitat von Tilman Schmidt : > >> One of my Bacula servers backs up 18 clients. Many of these >> have a lengthy ClientRunBeforeJob. (SVN hot backups, database >> dumps, Windows system state backups - you get the picture.) >> As a consequence, more tha

Re: [Bacula-users] Data encryption fails if backed up from fifo

2013-01-17 Thread lst_hoe02
Zitat von Axel Rau : > Am 15.01.2013 um 23:05 schrieb Axel Rau: > >> Files backed up with >> readfifo = yes >> seem to be backed up fine: >> --- >> Software Compression: None >> VSS:no >> Encryption: yes >> Accurate: no >> Volume name(s):

Re: [Bacula-users] save DB's online

2013-01-17 Thread lst_hoe02
Zitat von Sven Gehr : > Hi@all, > > is it possible to backu databases e.g. mysql, pgsql (on other hosts) > with bacula online? There are many different possibilities: - Use the dump utility of the DB to get a consistent dump to backup maybe with a ClientRunBeforeJob - Use the DB provided pos

Re: [Bacula-users] Data encryption fails if backed up from fifo

2013-01-17 Thread Axel Rau
Am 15.01.2013 um 23:05 schrieb Axel Rau: > Files backed up with > readfifo = yes > seem to be backed up fine: > --- > Software Compression: None > VSS:no > Encryption: yes > Accurate: no > Volume name(s): DB1-DB-DAILY-0120 > Volu

Re: [Bacula-users] parallelizing ClientRunBeforeJobs

2013-01-17 Thread lst_hoe02
Zitat von Tilman Schmidt : > One of my Bacula servers backs up 18 clients. Many of these > have a lengthy ClientRunBeforeJob. (SVN hot backups, database > dumps, Windows system state backups - you get the picture.) > As a consequence, more than half of the elapsed time of my > nightly backup runs

Re: [Bacula-users] parallelizing ClientRunBeforeJobs

2013-01-17 Thread Radosław Korzeniewski
Hello, 2013/1/17 Tilman Schmidt > One of my Bacula servers backs up 18 clients. Many of these > have a lengthy ClientRunBeforeJob. (SVN hot backups, database > dumps, Windows system state backups - you get the picture.) > As a consequence, more than half of the elapsed time of my > nightly backu

Re: [Bacula-users] save DB's online

2013-01-17 Thread Uwe Schuerkamp
On Thu, Jan 17, 2013 at 10:40:26AM +0100, Sven Gehr wrote: > Hi@all, > > is it possible to backu databases e.g. mysql, pgsql (on other hosts) > with bacula online? > > -- > Viele Grüsse > > Sven Gehr > Yes and no. If there are no jobs running you can set the db to read only, but bacula will

[Bacula-users] parallelizing ClientRunBeforeJobs

2013-01-17 Thread Tilman Schmidt
One of my Bacula servers backs up 18 clients. Many of these have a lengthy ClientRunBeforeJob. (SVN hot backups, database dumps, Windows system state backups - you get the picture.) As a consequence, more than half of the elapsed time of my nightly backup runs is actually spent waiting for one of t

[Bacula-users] save DB's online

2013-01-17 Thread Sven Gehr
Hi@all, is it possible to backu databases e.g. mysql, pgsql (on other hosts) with bacula online? -- Viele Grüsse Sven Gehr -- Viele Grüsse Sven Gehr -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5

Re: [Bacula-users] Tape Library and Cleaning Requests?

2013-01-17 Thread Jummo
Hi Frank, On Wed, 16 Jan 2013, f.staed...@dafuer.de wrote: > just another question I stumbled upon. While doing more testing with a > tape library and my rather large backup sets I came across a new > question. A single full backup of one machine is about 30 TB and while a > full backup is running