On Tue, Jun 04, 2013 at 01:28:07PM -0400, Mingus Dew wrote:
> Dear All,
> I have an existing Bacula installation that uses separate disk pools
> for Incremental and Full backups. I have setup a Copy Job to tape pool
> setup using the PoolUncopiedJobs Selection Type for the Full disk pool
> only.
>
> I now wish to set this up for the Incremental pool, but only from now
> moving forward. My concern is that the first run of the Copy Job will
> select all the current Jobs in the Incremental Pool, which would put 3
> previous weeks of Inrementals onto 1 weeks tapes.
>
> Does anyone have any suggestions on how to avoid this?
>
> Sincere Thanks,
> Shon
Your best bet would be to come up with a custom sql query that selects
the incrementals you want, maybe something like
select jobid from Job ...... where .... AND Job.RealEndTime > NOW()
or similar (this is from memory).
Be warned though that copy jobs can blow up your catalogs and
databases to humongous sizes. At one point, we ended up with 1,2 *billion*
rows in the File table alone, so take a good look at your retention
times. We've sinced moved away completely from copy jobs and write the
full volumes to tape once a month (just the on-disk volumes).
Let me know if you need a complete example for the sql query, I hope
this puts you on your way.
All the best, Uwe
> ------------------------------------------------------------------------------
> How ServiceNow helps IT people transform IT departments:
> 1. A cloud service to automate IT design, transition and operations
> 2. Dashboards that offer high-level views of enterprise services
> 3. A single system of record for all IT processes
> http://p.sf.net/sfu/servicenow-d2d-j
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
--
uwe.schuerkamp AT nionex DOT net fon: [+49] 5242.91 - 4740, fax:-69 72
Hauptsitz: Avenwedder Str. 55, D-33311 Gütersloh, Germany
Registergericht Gütersloh HRB 4196, Geschäftsführer: H. Gosewehr, D. Suda
NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA
------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. A cloud service to automate IT design, transition and operations
2. Dashboards that offer high-level views of enterprise services
3. A single system of record for all IT processes
http://p.sf.net/sfu/servicenow-d2d-j
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|