Re: 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 aprob...@us.ibm.com ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 08/12/2013 08:03:59 PM: J. Pohlmann jpohlm...@shaw.ca Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu 08/12/2013 08:03 PM Please respond to ADSM: Dist Stor Manager ADSM-L@vm.marist.edu To ADSM-L@vm.marist.edu, 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:ADSM-L@VM.MARIST.EDU] On Behalf Of Angela Robertson Sent: Monday, August 12, 2013 16:48 To: ADSM-L@VM.MARIST.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
Re: 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:ADSM-L@VM.MARIST.EDU] On Behalf Of Angela Robertson Sent: Wednesday, August 14, 2013 08:40 To: ADSM-L@VM.MARIST.EDU 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 aprob...@us.ibm.com ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 08/12/2013 08:03:59 PM: J. Pohlmann jpohlm...@shaw.ca Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu 08/12/2013 08:03 PM Please respond to ADSM: Dist Stor Manager ADSM-L@vm.marist.edu To ADSM-L@vm.marist.edu, 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:ADSM-L@VM.MARIST.EDU] On Behalf Of Angela Robertson Sent: Monday, August 12, 2013 16:48 To: ADSM-L@VM.MARIST.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
Re: DP for SQL 6.4 Copyfull MC binding
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 aprob...@us.ibm.com ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 08/14/2013 12:04:39 PM: J. Pohlmann jpohlm...@shaw.ca Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu 08/14/2013 12:04 PM Please respond to ADSM: Dist Stor Manager ADSM-L@vm.marist.edu To ADSM-L@vm.marist.edu, 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:ADSM-L@VM.MARIST.EDU] On Behalf Of Angela Robertson Sent: Wednesday, August 14, 2013 08:40 To: ADSM-L@VM.MARIST.EDU 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 aprob...@us.ibm.com ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 08/12/2013 08:03:59 PM: J. Pohlmann jpohlm...@shaw.ca Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu 08/12/2013 08:03 PM Please respond to ADSM: Dist Stor Manager ADSM-L@vm.marist.edu To ADSM-L@vm.marist.edu, 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:ADSM-L@VM.MARIST.EDU] On Behalf Of Angela Robertson Sent: Monday, August 12, 2013 16:48 To: ADSM-L@VM.MARIST.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* |
Re: 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
Re: 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:ADSM-L@VM.MARIST.EDU] On Behalf Of Angela Robertson Sent: Monday, August 12, 2013 16:48 To: ADSM-L@VM.MARIST.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