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
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
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
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
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,
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
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
23 matches
Mail list logo
