Thanks for looking at this.
I am a bit redfaced right now, because it looks like I have to withdraw the
question. When I used "bat" to view the Jobs Run, and clicked "Filter Copy
Jobs", a lot of the confusing stuff was removed, and I could see that the
dates actually had a monotonically increasing
On Tuesday 2015-09-01 20:37:52 Greg Woods wrote:
> I have a job called ARCHIVE-ALL that looks like this:
>
> JobDefs {
> Name = "ArchiveJob"
> Type = Copy
> Level = Full
> Selection Type = SQLQuery
> Messages = Standard
> File Set = Copy
> Pool = File
> }
>
> # Copy (to archive) all
Hello,
2015-09-02 4:37 GMT+02:00 Greg Woods :
> I have a job called ARCHIVE-ALL that looks like this:
>
> JobDefs {
> Name = "ArchiveJob"
> Type = Copy
> Level = Full
> Selection Type = SQLQuery
> Messages = Standard
> File Set = Copy
> Pool = File
> }
>
> # Copy (to archive) all no
I have a job called ARCHIVE-ALL that looks like this:
JobDefs {
Name = "ArchiveJob"
Type = Copy
Level = Full
Selection Type = SQLQuery
Messages = Standard
File Set = Copy
Pool = File
}
# Copy (to archive) all not-already-copied successful backup jobs
Job {
JobDefs = ArchiveJob
On Thu, Feb 14, 2013 at 11:04:23AM +0100, Masopust, Christian wrote:
> So... some questions left:
> - can the size of "Selection Pattern" be increased (probably without
> increasing
> it for all other parameter values) ?
> - why are stored procedures not possible in this case?
>
> Thanks,
> Chr
> >
> > :List all Jobs needed for a disaster recovery for a jobname:
> > *Enter Job name:
> > SELECT DISTINCT Job.JobId,StartTime FROM Job WHERE
> Job.Name = '%1' AND (
> > (Level='F' AND JobStatus IN ('T', 'W') AND
> > Job.StartTime >= (
> > SELECT DISTINCT StartTime
> > FROM
On Wed, Feb 13, 2013 at 08:08:34PM +0100, Masopust, Christian wrote:
>
> :List all Jobs needed for a disaster recovery for a jobname:
> *Enter Job name:
> SELECT DISTINCT Job.JobId,StartTime FROM Job WHERE Job.Name = '%1' AND (
> (Level='F' AND JobStatus IN ('T', 'W') AND
> Job.StartTime >=
> Hi Uwe,
>
> thanks for reminding me about the query.sql :) Starting from
> there I found
> now a way to create a query that includes the most recent
> full, the latest
> differential and all incrementals since the latest
> differentials (see below).
>
> It is definitly working here for me
> > I'd like to set up a copy job here for offsite backup (on
> demand) and therefore would need
> > a fine SQL-query to get all jobs listed for the most recend
> full and all following differentials
> > and incrementals. All backups are to one single pool.
> >
> > As said, the offsite backup sh
On Wed, Feb 13, 2013 at 08:26:38AM +0100, Masopust, Christian wrote:
> Hi,
>
> I'd like to set up a copy job here for offsite backup (on demand) and
> therefore would need
> a fine SQL-query to get all jobs listed for the most recend full and all
> following differentials
> and incrementals. All
Hi,
I'd like to set up a copy job here for offsite backup (on demand) and therefore
would need
a fine SQL-query to get all jobs listed for the most recend full and all
following differentials
and incrementals. All backups are to one single pool.
As said, the offsite backup should be done on dem
On Mon, Dec 24, 2012 at 05:48:35PM -0500, K. M. Peterson wrote:
> Hi Mark,
>
> I have two jobs that I run periodically.
>
> query_errvols.sql generates a list of volumes that were written by failed
> jobs. If a job failed, or was cancelled, it gets returned by this program.
> query_orphan_volume
Hi Mark,
I have two jobs that I run periodically.
query_errvols.sql generates a list of volumes that were written by failed
jobs. If a job failed, or was cancelled, it gets returned by this program.
query_orphan_volumes.sql does the same for volumes that are in the Media
table with no correspond
I believe we have a significant number of tapes that bacula thinks are
"full" but which no longer have jobs. These tapes were used normally
and became full. Later we decommissioned the machines that were backed
up to those tapes and pruned & purged the bacula jobs that referenced
the decommissione
Hi Folks,
I need to know how much disk space my full backups are in use for the
last backup run.
Thanks in advance,
--
Isamar Maia
Cel. VIVO SSA: (55) 71-9146-8575
Cel. TIM SSA: (55) 71-9185-5264
Fixo: (55) 71-4062-8688
日本: +81-(0)3-4550-1212
Skype ID: isamar.maia
On Mar 30, 2011, at 10:20 PM, Dan Langille wrote:
> On Mar 30, 2011, at 4:46 PM, Rodrigo Renie Braga wrote:
>
>> Hello list.
>>
>> Can someone send me the SQL Query to get the size that all my Full, Diff and
>> Inc backups are currently consuming? In my config, I have 5 Pools that store
>> Ful
On Mar 30, 2011, at 4:46 PM, Rodrigo Renie Braga wrote:
> Hello list.
>
> Can someone send me the SQL Query to get the size that all my Full, Diff and
> Inc backups are currently consuming? In my config, I have 5 Pools that store
> Full Backup tapes, the same happens for Diff and Inc Backups. B
You can start from below.
select Level,sum(JobBytes) from Job group by Level;
Kleber
2011/3/30 Rodrigo Renie Braga
> Hello list.
>
> Can someone send me the SQL Query to get the size that all my Full, Diff
> and Inc backups are currently consuming? In my config, I have 5 Pools that
> store Ful
Hello list.
Can someone send me the SQL Query to get the size that all my Full, Diff and
Inc backups are currently consuming? In my config, I have 5 Pools that store
Full Backup tapes, the same happens for Diff and Inc Backups. But if you
send me a SQL Query.
I'm going to use this to know when sh
On 18/02/2011 7:28 PM, Dan Langille wrote:
> On 2/17/2011 8:49 PM, Jim Barber wrote:
>> On 17/02/2011 6:54 PM, Torsten Maus wrote:
>>>
>>> My idea is that I copy the LAST Full Backups of ALL Clients to Tape.
>>> Hence, since I am not familiar with the SQL commands so well, I am
>>> looking for supp
On 2/17/2011 8:49 PM, Jim Barber wrote:
> On 17/02/2011 6:54 PM, Torsten Maus wrote:
>>
>> My idea is that I copy the LAST Full Backups of ALL Clients to Tape.
>> Hence, since I am not familiar with the SQL commands so well, I am
>> looking for support from your side for such a pattern
>>
>> The on
Please ignore my previous suggestion. It was completely wrong. Sorry.
--
Dan Langille - http://langille.org/
--
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading er
On 2/17/2011 8:49 PM, Jim Barber wrote:
> On 17/02/2011 6:54 PM, Torsten Maus wrote:
>>
>> My idea is that I copy the LAST Full Backups of ALL Clients to Tape.
>> Hence, since I am not familiar with the SQL commands so well, I am
>> looking for support from your side for such a pattern
>>
>> The on
On 17/02/2011 6:54 PM, Torsten Maus wrote:
My idea is that I copy the LAST Full
Backups of ALL Clients to Tape. Hence, since I am not familiar
with the SQL commands so well, I am looking for support from
your side for such a pattern
Hi guys,
I am currently trying to implement Copy Jobs into my Backup environemnt. I want
to use SQL Query patterns as type of selction.
My idea is that I copy the LAST Full Backups of ALL Clients to Tape. Hence,
since I am not familiar with the SQL commands so well, I am looking for support
f
Hi,
Martin Simmons a écrit :
>> On Wed, 13 Jan 2010 14:18:18 +0100, David Dumortier said:
>> Importance: Normal
>>
>> Hi all,
>>
>> I try to query MySQL to obtain all the date of backup for a file.
>> I used this but have only the last backup :
>>
>> :List all backup for a File with date :
>>
> On Wed, 13 Jan 2010 14:18:18 +0100, David Dumortier said:
> Importance: Normal
>
> Hi all,
>
> I try to query MySQL to obtain all the date of backup for a file.
> I used this but have only the last backup :
>
> :List all backup for a File with date :
> *Enter Client :
> *Enter Filename (no
Hi all,
I try to query MySQL to obtain all the date of backup for a file.
I used this but have only the last backup :
:List all backup for a File with date :
*Enter Client :
*Enter Filename (no path) :
SELECT Client.Name as Client,
Path.Path,Filename.Name, Job.JobId as JobId,
StartTime
FROM
Hi,
does anyone have a custom sql query to get all volume files?
Something like
12: List Files for a selected Job
but for volumes. I tried a combination of query 12 and
14: List Jobs stored for a given Volume name
But my query was a bit suboptimal... :/
Out of memory: kill process 32013 (bacu
I believe that someone was asking for an SQL query to report on the assignment
of pools to volumes. Perhaps this will help...it lists volumes in each pool,
after prompting for the pool name. Suggestions in improving the SQL are welcome.
==
Wonderful. This is a good start.
Thanks Alan.
Erich
On Aug 13, 2007, at 10:40 AM, Alan Brown wrote:
> On Mon, 13 Aug 2007, Erich Prinz wrote:
>
>>
>> Had a failure occur that prevented the usual running of Full backups.
>>
>> Looking for a 'how to' query to find the most recent Full backup of
On Mon, 13 Aug 2007, Erich Prinz wrote:
>
> Had a failure occur that prevented the usual running of Full backups.
>
> Looking for a 'how to' query to find the most recent Full backup of
> all clients to see how far off we are into Incrementals / Diffs from
> an actual Full.
>
> Any SQL gurus on th
Had a failure occur that prevented the usual running of Full backups.
Looking for a 'how to' query to find the most recent Full backup of
all clients to see how far off we are into Incrementals / Diffs from
an actual Full.
Any SQL gurus on the list that can help?
Erich
Here's an sql query I wrote to tell me which tapes that are in the autochanger
are in need of replacment:
---
# 18
:List Volumes in the changer that are in need of replacement
SELECT VolumeName,Storage.Name AS Storage,Slot,Pool.Name AS
Pool,MediaType,VolS
34 matches
Mail list logo
