Hi Joerg, Thanks to some help, I have an update:
VSSPOLICY * * COPY TSM VSS_FULL_TSM_MC I'm glad this helps. Angela ---------------------------------------------------------------- Angela Robertson IBM Software Group Durham, NC 27703 [email protected] ---------------------------------------------------------------- "ADSM: Dist Stor Manager" <[email protected]> wrote on 08/14/2013 12:04:39 PM: > "J. Pohlmann" <[email protected]> > Sent by: "ADSM: Dist Stor Manager" <[email protected]> > > 08/14/2013 12:04 PM > > Please respond to > "ADSM: Dist Stor Manager" <[email protected]> > > To > > [email protected], > > cc > > Subject > > Re: [ADSM-L] DP for SQL 6.4 Copyfull MC binding > > Thanks Angela. All very intuitive. I just wanted to be sure. > > Regards, > > Joerg Pohlmann > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of > Angela Robertson > Sent: Wednesday, August 14, 2013 08:40 > To: [email protected] > Subject: Re: [ADSM-L] DP for SQL 6.4 Copyfull MC binding > > Hi Joerg, > > I am happy to help. Here's the information to answer your question: > > VSSPOLICY * * COPYFULL TSM VSS_FULL_TSM_MC > > If I can provide more detail, I will post. For now, I think this information > answers the immediate question. Angela > > ---------------------------------------------------------------- > Angela Robertson > IBM Software Group > Durham, NC 27703 > [email protected] > ---------------------------------------------------------------- > > "ADSM: Dist Stor Manager" <[email protected]> wrote on 08/12/2013 > 08:03:59 PM: > > > "J. Pohlmann" <[email protected]> > > Sent by: "ADSM: Dist Stor Manager" <[email protected]> > > > > 08/12/2013 08:03 PM > > > > Please respond to > > "ADSM: Dist Stor Manager" <[email protected]> > > > > To > > > > [email protected], > > > > cc > > > > Subject > > > > Re: [ADSM-L] DP for SQL 6.4 Copyfull MC binding > > > > > Thanks Angela. What about the VSSPOLICY specification? > > > > Thanks for your help. > > > > Regards, > > > > Joerg Pohlmann > > > > -----Original Message----- > > From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf > > Of Angela Robertson > > Sent: Monday, August 12, 2013 16:48 > > To: [email protected] > > 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 > > [email protected] > > ---------------------------------------------------------------- > > > > "ADSM: Dist Stor Manager" <[email protected]> wrote on 08/12/2013 > > 06:25:30 PM: > > > > > "J. Pohlmann" <[email protected]> > > > Sent by: "ADSM: Dist Stor Manager" <[email protected]> > > > > > > 08/12/2013 06:25 PM > > > > > > Please respond to > > > "ADSM: Dist Stor Manager" <[email protected]> > > > > > > To > > > > > > [email protected], > > > > > > 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 > > >= > >= >
