Thanks Angela. What about the VSSPOLICY specification?
Thanks for your help.
Regards,
Joerg Pohlmann
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Angela Robertson
Sent: Monday, August 12, 2013 16:48
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] DP for SQL 6.4 Copyfull MC binding
Here is some information that might help. There's more information than you
asked for, but I hope you find the additional detail helpful.
Legacy backups use INCLUDE/EXCLUDE statements in the Data Protection for SQL
options file. For the examples provided in the following tables, grouped
statements are intended to be used together. For example:
\...\full*
\...\full*\*
and
\...\file\f1*\*
\...\file\f1*
\...\f1\file*
|------------------------------------+------------------------------------|
|Object matches for backuptype |Specification |
|------------------------------------+------------------------------------|
|Example for all objects |\...\* |
|------------------------------------+------------------------------------|
|Example for exclude statements with |\...\full* |
|all type of backups | |
|(full, diff, log, group, file, set) |\...\diff* |
|------------------------------------+------------------------------------|
|Example for include and exclude |\...\full* |
|statements with all type of backups |\...\full*\* |
|(full, diff, log, group, file, set) | |
| |\...\copyfull* |
| |\...\copyfull*\* |
| | |
| |\...\diff* |
| |\...\diff*\* |
| | |
| |\...\log* |
| |\...\log\...\* |
| | |
| |\...\group* |
| |\...\group\...\* |
| | |
| |\...\file* |
| |\...\file\...\* |
| | |
| |\...\set* |
| |\...\set\...\* |
|------------------------------------+------------------------------------|
|Example for exclude statements with |\...\g1\group* |
|file (f1) and group (g1) |\...\f1\file* |
|------------------------------------+------------------------------------|
|Example for include statements with |\...\group\g1*\* |
|file (f1) and group (g1) |\...\group\g1* |
| |\...\g1\group* |
| | |
| |\...\file\f1*\* |
| |\...\file\f1* |
| |\...\f1\file* |
|------------------------------------+------------------------------------|
|Example for exclude statements with |\...\g*\group* |
|group or file object names beginning|\...\f*\file* |
|with g or f | |
|------------------------------------+------------------------------------|
|Example for include statements with |\...\group\g*\* |
|group or file object names beginning|\...\group\g* |
|with g or f |\...\g*\group* |
| | |
| |\...\file\f*\* |
| |\...\file\f* |
| |\...\f*\file* |
|------------------------------------+------------------------------------|
|Example for exclude statements same |\...\*\group* |
|as \...\group* or \...\file* (there |\...\*\file* |
|is no equivalent for include | |
|statements) | |
|------------------------------------+------------------------------------|
|------------------------------------+------------------------------------|
|backuptype object with database |Specification |
|matches | |
|------------------------------------+------------------------------------|
|Example for all objects with |\...\Db1\...\* |
|database name Db1 | |
|------------------------------------+------------------------------------|
|Example for all objects with |\...\Db*\...\* |
|database name Db1 beginning with Db | |
|------------------------------------+------------------------------------|
|Ambiguous |\...\*\...\* |
|------------------------------------+------------------------------------|
|Example for exclude statements using|\...\Db1\full* |
|full, diff, copyfull objects with |\...\Db1\copyfull* |
|database name Db1 |\...\Db1\diff* |
|------------------------------------+------------------------------------|
|Example for exclude and include |\...\Db1\full* |
|statements using full, diff, |\...\Db1\full*\* |
|copyfull objects with database name | |
|Db1 |\...\Db1\copyfull* |
| |\...\Db1\copyfull*\* |
| | |
| |\...\Db1\diff* |
| |\...\Db1\diff*\* |
|------------------------------------+------------------------------------|
|Example for exclude statements using|\...\Db1\...\log* |
|log, group, file, set objects with |\...\Db1\...\group* |
|database name Db1 | |
|------------------------------------+------------------------------------|
|Example for exclude and include |\...\Db1\...\log* |
|statements using log, group, file, |\...\Db1\...\log*\...\* |
|set objects with database name Db1 | |
| |\...\Db1\...\group* |
| |\...\Db1\...\group*\...\* |
| | |
| |\...\Db1\...\file* |
| |\...\Db1\...\file*\...\* |
| | |
| |\...\Db1\...\set* |
| |\...\Db1\...\set*\...\* |
|------------------------------------+------------------------------------|
|Example for exclude statements using|\...\Db1\g1\group* |
|all group or file object names (g1, |\...\Db1\f1\file* |
|f1) with database name Db1 | |
|------------------------------------+------------------------------------|
|Example for exclude and include |\...\Db1\group\g1* |
|statements using all group or file |\...\Db1\group\g1*\* |
|object names (g1, f1) with database |\...\Db1\g1\group* |
|name Db1 | |
| |\...\Db1\file\f1* |
| |\...\Db1\file\f1*\* |
| |\...\Db1\f1\file* |
|------------------------------------+------------------------------------|
|Example for exclude statements using|\...\Db1\g*\group* |
|all group or file object names |\...\Db1\f*\file* |
|beginning with g or f with database | |
|name Db1 | |
|------------------------------------+------------------------------------|
|Example for exclude and include |\...\Db1\group\g* |
|statements using all group or file |\...\Db1\group\g*\* |
|object names beginning with g or f |\...\Db1\g*\group* |
|with database name Db1 | |
| |\...\Db1\file\f* |
| |\...\Db1\file\f*\* |
| |\...\Db1\f*\file* |
|------------------------------------+------------------------------------|
|Example for exclude statements using|\...\Db1\*\group* |
|\...\Db1\...\group* or file* (there |\...\Db1\*\file* |
|is no equivalent for include | |
|statements) | |
|------------------------------------+------------------------------------|
|Example for exclude statements using|\...\Db1\...\full* |
|\...\Db1\full* | |
|------------------------------------+------------------------------------|
|Example for exclude and include |\...\Db1\...\full* |
|statements using \...\Db1\full* |\...\Db1\...\full*\* |
|------------------------------------+------------------------------------|
|Example for exclude statements using|\...\*\full* |
|\...\full* | |
|------------------------------------+------------------------------------|
|Example for exclude and include |\...\*\full* |
|statements using \...\full* |\...\*\full*\* |
|------------------------------------+------------------------------------|
|Example for exclude statements using|\...\*\*\group* |
|\...\group* (there is no equivalent | |
|for include statements) | |
|------------------------------------+------------------------------------|
|Example for exclude statements using|\...\*\g1\group* |
|\...\g1\group* (there is no | |
|equivalent for include statements) | |
|------------------------------------+------------------------------------|
|Ambiguous |\...\*\...\log* |
|------------------------------------+------------------------------------|
|Nothing (typeInfo missing) |\...\Db1\set* |
|------------------------------------+------------------------------------|
For the following table, use the following guidelines:
If you use using only exclude statements with only \meta\, all objects
(including data) are excluded.
If you are using only exclude statements with only \data\, errors occur.
|------------------------------------+------------------------------------|
|Meta and data object matches |Specification |
|------------------------------------+------------------------------------|
|Example for all meta or data objects|\...\meta\...\* |
| |\...\data\...\* |
|------------------------------------+------------------------------------|
|Example for all meta full objects |\...\meta\...\full* |
|------------------------------------+------------------------------------|
|Example for all data full objects |\...\data\...\full* |
| |\...\data\...\full*\* |
|------------------------------------+------------------------------------|
|Example for all meta group object |\...\meta\...\g1\group* |
|names (g1) | |
|------------------------------------+------------------------------------|
|Example for all data group object |\...\data\...\group\g1* |
|names (g1) |\...\data\...\group\g1*\* |
|------------------------------------+------------------------------------|
|Example for all meta group object |\...\meta\...\g*\group* |
|names beginning with g | |
|------------------------------------+------------------------------------|
|Example for all data group object |\...\data\...\group\g* |
|names beginning with g |\...\data\...\group\g*\* |
|------------------------------------+------------------------------------|
|Same as \...\meta\...\group* |\...\meta\...\*\group* |
|------------------------------------+------------------------------------|
|Nothing (qualifiers missing) |\...\meta\*\...\data\* |
|------------------------------------+------------------------------------|
|------------------------------------+------------------------------------|
|Meta and data object with database |Specification |
|matches | |
|------------------------------------+------------------------------------|
|Example for all meta or data objects|\...\meta\...\Db1\...\* |
|with database name Db1 |\...\data\...\Db1\...\* |
|------------------------------------+------------------------------------|
|Example for all meta objects with |\...\meta\...\Db1\full* |
|database name Db1 | |
|------------------------------------+------------------------------------|
|Example for full objects matching |\...\data\...\Db1\full* |
|all data objects |\...\data\...\Db1\full*\* |
|------------------------------------+------------------------------------|
|Example for all meta objects with |\...\meta\...\Db1\...\log* |
|database name Db1 | |
|------------------------------------+------------------------------------|
|Example for all log objects matching|\...\data\...\Db1\...\log\...\* |
|all data objects | |
|------------------------------------+------------------------------------|
|Example for all group matching all |\...\meta\...\Db1\...\group* |
|meta objects | |
|------------------------------------+------------------------------------|
|Example for group matching all data |\...\data\...\Db1\group\...\* |
|objects | |
|------------------------------------+------------------------------------|
|Example for all meta object names ( |\...\meta\...\Db1\g1\group* |
|g1) with database name Db1 | |
|------------------------------------+------------------------------------|
|Example for all data group object |\...\data\...\Db1\group\g1* |
|names (g1) with database name Db1 | |
|------------------------------------+------------------------------------|
|Example for all meta object names |\...\meta\...\Db1\g*\group* |
|beginning with g with database name | |
|Db1 | |
|------------------------------------+------------------------------------|
|Example for all data group object |\...\data\...\Db1\group\g* |
|names beginning with g with database| |
|name Db1 | |
|------------------------------------+------------------------------------|
|Same as \...\meta\...\Db1\...\group*|\...\meta\...\Db1\*\group* |
|(No equivalent for data objects) | |
|------------------------------------+------------------------------------|
|Same as \...\meta\...\full* (No |\...\meta\...\*\full* |
|equivalent for data objects) | |
|------------------------------------+------------------------------------|
|Same as \...\meta\...\group* (No |\...\meta\...\*\*\group* |
|equivalent for data objects) | |
|------------------------------------+------------------------------------|
|Same as \...\meta\...\g1\group* (No |\...\meta\...\*\g1\group* |
|equivalent for data objects) | |
|------------------------------------+------------------------------------|
|Ambiguous |\...\meta\...\*\...\log* |
| |\...\data\...\*\...\log* |
|------------------------------------+------------------------------------|
|Nothing (qualifiers missing) |\...\meta\*\...\data\* |
|------------------------------------+------------------------------------|
|------------------------------------+------------------------------------|
|Server matches |Specification |
|------------------------------------+------------------------------------|
|Example for all objects from all |SQL*\...\* |
|servers beginning with SQL | |
|------------------------------------+------------------------------------|
|Example for all objects from all |SQL2012\...\* |
|server instances with host SQL2012 | |
|------------------------------------+------------------------------------|
|Example for all objects from server |SQL2012\INST1\...\* |
|SQL2012\INST1 | |
|------------------------------------+------------------------------------|
|Example for all objects from all |SQL2012\INST*\...\* |
|servers beginning with SQL2012\INST | |
|------------------------------------+------------------------------------|
|Same as SQL2012\...\* |SQL2012\*\...\* |
|------------------------------------+------------------------------------|
|Example for all meta or data objects|SQL2012\INST1\meta\...\* |
|from server SQL2012\INST1 |SQL2012\INST1\data\...\* |
|------------------------------------+------------------------------------|
|Example for all meta or data objects|SQL2012\*\meta\...\* |
|from all named server instances with| |
|host SQL2012 | |
|------------------------------------+------------------------------------|
|Example for all meta or data objects|SQL2012\...\meta\...\* |
|from all server instances with host | |
|SQL2012 | |
|------------------------------------+------------------------------------|
|Example for all objects from server |SQL2012\meta\...\* |
|default instance (if no instance |SQL2012\data\...\* |
|name matches ??ta) | |
|------------------------------------+------------------------------------|
----------------------------------------------------------------
Angela Robertson
IBM Software Group
Durham, NC 27703
aprobert AT us.ibm DOT com
----------------------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 08/12/2013
06:25:30 PM:
> "J. Pohlmann" <jpohlmann AT SHAW DOT CA>
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> 08/12/2013 06:25 PM
>
> Please respond to
> "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> To
>
> ADSM-L AT vm.marist DOT edu,
>
> cc
>
> Subject
>
> [ADSM-L] DP for SQL 6.4 Copyfull MC binding
>
> We are thinking of upgrading our DP for SQL environment to 6.4 so that
> we can take advantage of the copyfull type of backup. We would like to
> bind
a
> long-term retention MC to the copyfull backup, however the DP for SQL
> Installation and User's Guide (GC27-4010-10) does not cover this (page
> 3 states that different MCs can be bound to full and copyfull
> backups). If
we
> are going to use VSS backups, then we expect that VSSPOLICY statements
will
> do the MC binding. On page 43 at the revision bars, there is a
> statement that only FULL or a * can be used for the backup type, where
> a * will
cause
> a FULL backup to be taken. However on p 91 an example of VSSPOLICY
> shows FULL and INCR type of backups. There is no INCR type of backup
> for SQL (there is for DP for Exchange). Page 253 only shows FULL
> backup type examples for VSSPOLICY.
>
>
>
> If we were to use a COPYFULL with legacy backups, what would the
> include pattern be for the include statement to assign a long-term
retention MC?
> Page 254 (at the top) only shows the include pattern for the
> previously supported legacy backup types.
>
>
>
> Please help with the settings.
>
>
>
> Regards,
>
>
>
> Joerg Pohlmann
>=
|