IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server V6.4 Documentation Updates

A paragraph is missing from the Planning for Data Protection for Microsoft SQL Server operations -> Backup strategies topic. This topic is available in the following locations:

• http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/index.jsp?topic=%2Fcom.ibm.itsm.db.sql.doc%2Fdps_con_bup_strategies.html
• http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/topic/com.ibm.itsm.db.sql.doc/b_dp_sql_iuguide.pdf - page 22 -> Chapter 2. Planning for Data Protection for Microsoft SQL Server operations -> Backup strategies

The following statement is missing from the original publication:

The PRIMARY filegroup must be restored prior to restoring a user-defined filegroup. Ensure that you are able to restore the PRIMARY filegroup backup by taking a full backup or a group backup of the PRIMARY filegroup before taking the user-defined backup.

The following information is not missing in the published document, but is key to this discussion: File, group, and set backups must be followed by a log backup, but a full is not required.
-----------------------------------------------------------------------------------------------------------------------------------------------

A paragraph is missing from the Protecting Microsoft SQL Server data -> Restoring SQL databases and files -> Restoring SQL file groups and files from Legacy backups topic. This topic is available in the following locations:

• http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/index.jsp?topic=%2Fcom.ibm.itsm.db.sql.doc%2Fdps_tsk_gui_restoregroupsfiles.html
• http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/topic/com.ibm.itsm.db.sql.doc/b_dp_sql_iuguide.pdf - page 105 -> Chapter 5. Protecting Microsoft SQL Server data -> Restoring SQL databases and files -> Restoring SQL file groups and files from Legacy backups

The following statement is missing from the original publication:

Microsoft SQL Server requires that the PRIMARY filegroup is restored before or along with a user-defined filegroup. To bring the database back to a usable state a log restore must be performed after the user-defined filegroup is restored.
-----------------------------------------------------------------------------------------------------------------------------------------------
The legacy examples in the "Examples of Tivoli Storage Manager policy binding using include/exclude and VSSPOLICY statements" topic have been updated. The backup objects are processed differently from earlier releases.

This topic is available in the following locations:

• http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/index.jsp?topic=%2Fcom.ibm.itsm.db.sql.doc%2Fdps_ref_opt_includeexclude.html
• http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/topic/com.ibm.itsm.db.sql.doc/b_dp_sql_iuguide.pdf - page 105 -> Chapter 8. Data Protection for Microsoft SQL Server reference -> Changetsmpassword command -> Examples of Tivoli Storage Manager policy binding using include/exclude and VSSPOLICY statements

The following information includes all updated legacy examples:

Legacy examples

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 all type of backups (full, diff, log, group, file, set)	\...\full* \...\diff*
Example for include and exclude statements with all type of backups (full, diff, log, group, file, set)	\...\full* \...\full*\* \...\copyfull* \...\copyfull*\* \...\diff* \...\diff*\* \...\log* \...\log\...\* \...\group* \...\group\...\* \...\file* \...\file\...\* \...\set* \...\set\...\*
Example for exclude statements with file (f1) and group (g1)	\...\g1\group* \...\f1\file*
Example for include statements with file (f1) and group (g1)	\...\group\g1*\* \...\group\g1* \...\g1\group* \...\file\f1*\* \...\file\f1* \...\f1\file*
Example for exclude statements with group or file object names beginning with g or f	\...\g*\group* \...\f*\file*
Example for include statements with group or file object names beginning with g or f	\...\group\g*\* \...\group\g* \...\g*\group* \...\file\f*\* \...\file\f* \...\f*\file*
Example for exclude statements same as \...\group* or \...\file* (there is no equivalent for include statements)	\...\*\group* \...\*\file*

backuptype object with database matches	Specification
Example for all objects with database name Db1	\...\Db1\...\*
Example for all objects with database name Db1 beginning with Db	\...\Db*\...\*
Ambiguous	\...\*\...\*
Example for exclude statements using full, diff, copyfull objects with database name Db1	\...\Db1\full* \...\Db1\copyfull* \...\Db1\diff*
Example for exclude and include statements using full, diff, copyfull objects with database name Db1	\...\Db1\full* \...\Db1\full*\* \...\Db1\copyfull* \...\Db1\copyfull*\* \...\Db1\diff* \...\Db1\diff*\*
Example for exclude statements using log, group, file, set objects with database name Db1	\...\Db1\...\log* \...\Db1\...\group*
Example for exclude and include statements using log, group, file, set objects with database name Db1	\...\Db1\...\log* \...\Db1\...\log*\...\* \...\Db1\...\group* \...\Db1\...\group*\...\* \...\Db1\...\file* \...\Db1\...\file*\...\* \...\Db1\...\set* \...\Db1\...\set*\...\*
Example for exclude statements using all group or file object names (g1, f1) with database name Db1	\...\Db1\g1\group* \...\Db1\f1\file*
Example for exclude and include statements using all group or file object names (g1, f1) with database name Db1	\...\Db1\group\g1* \...\Db1\group\g1*\* \...\Db1\g1\group* \...\Db1\file\f1* \...\Db1\file\f1*\* \...\Db1\f1\file*
Example for exclude statements using all group or file object names beginning with g or f with database name Db1	\...\Db1\g*\group* \...\Db1\f*\file*
Example for exclude and include statements using all group or file object names beginning with g or f with database name Db1	\...\Db1\group\g* \...\Db1\group\g*\* \...\Db1\g*\group* \...\Db1\file\f* \...\Db1\file\f*\* \...\Db1\f*\file*
Example for exclude statements using \...\Db1\...\group* or file* (there is no equivalent for include statements)	\...\Db1\*\group* \...\Db1\*\file*
Example for exclude statements using \...\Db1\full*	\...\Db1\...\full*
Example for exclude and include statements using \...\Db1\full*	\...\Db1\...\full* \...\Db1\...\full*\*
Example for exclude statements using \...\full*	\...\*\full*
Example for exclude and include statements using \...\full*	\...\*\full* \...\*\full*\*
Example for exclude statements using \...\group* (there is no equivalent for include statements)	\...\*\*\group*
Example for exclude statements using \...\g1\group* (there is no equivalent for include statements)	\...\*\g1\group*
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 names (g1)	\...\meta\...\g1\group*
Example for all data group object names (g1)	\...\data\...\group\g1* \...\data\...\group\g1*\*
Example for all meta group object names beginning with g	\...\meta\...\g*\group*
Example for all data group object names beginning with g	\...\data\...\group\g* \...\data\...\group\g*\*
Same as \...\meta\...\group*	\...\meta\...\*\group*
Nothing (qualifiers missing)	\...\meta\*\...\data\*

Meta and data object with database matches	Specification
Example for all meta or data objects with database name Db1	\...\meta\...\Db1\...\* \...\data\...\Db1\...\*
Example for all meta objects with database name Db1	\...\meta\...\Db1\full*
Example for full objects matching all data objects	\...\data\...\Db1\full* \...\data\...\Db1\full*\*
Example for all meta objects with database name Db1	\...\meta\...\Db1\...\log*
Example for all log objects matching all data objects	\...\data\...\Db1\...\log\...\*
Example for all group matching all meta objects	\...\meta\...\Db1\...\group*
Example for group matching all data objects	\...\data\...\Db1\group\...\*
Example for all meta object names (g1) with database name Db1	\...\meta\...\Db1\g1\group*
Example for all data group object names (g1) with database name Db1	\...\data\...\Db1\group\g1*
Example for all meta object names beginning with g with database name Db1	\...\meta\...\Db1\g*\group*
Example for all data group object names beginning with g with database name Db1	\...\data\...\Db1\group\g*
Same as \...\meta\...\Db1\...\group* (No equivalent for data objects)	\...\meta\...\Db1\*\group*
Same as \...\meta\...\full* (No equivalent for data objects)	\...\meta\...\*\full*
Same as \...\meta\...\group* (No equivalent for data objects)	\...\meta\...\*\*\group*
Same as \...\meta\...\g1\group* (No equivalent for data objects)	\...\meta\...\*\g1\group*
Ambiguous	\...\meta\...\*\...\log* \...\data\...\*\...\log*
Nothing (qualifiers missing)	\...\meta\*\...\data\*

Server matches	Specification
Example for all objects from all servers beginning with SQL	SQL*\...\*
Example for all objects from all server instances with host SQL2012	SQL2012\...\*
Example for all objects from server SQL2012\INST1	SQL2012\INST1\...\*
Example for all objects from all servers beginning with SQL2012\INST	SQL2012\INST*\...\*
Same as SQL2012\...\*	SQL2012\*\...\*
Example for all meta or data objects from server SQL2012\INST1	SQL2012\INST1\meta\...\* SQL2012\INST1\data\...\*
Example for all meta or data objects from all named server instances with host SQL2012	SQL2012\*\meta\...\*
Example for all meta or data objects from all server instances with host SQL2012	SQL2012\...\meta\...\*
Example for all objects from server default instance (if no instance name matches ??ta)	SQL2012\meta\...\* SQL2012\data\...\*

-----------------------------------------------------------------------------------------------------------------------------------------------

For the 6.4 information deliverables, in the following topics, when you read the /QUERYNode parameter, add the BOTH option:

• Data Protection for Microsoft SQL reference -> Query command -> Query optional parameters
• Data Protection for Microsoft SQL reference -> Restore command -> Restore syntax
• Data Protection for Microsoft SQL reference -> Restore command -> Restore optional parameters

In summary, for the /QUERYNode parameter, there are three options:

• DP
• ALWAYSON
• BOTH

For convenience, here's the description of the /QUERYNode parameter: Use to specify whether you want to query standard databases from SQL Server
2012 that were backed up from a standard Data Protection for SQL node or
the AlwaysOn node. This parameter is ignored for availability databases
because the availability databases are always backed up under the
AlwaysOn node.

-----------------------------------------------------------------------------------------------------------------------------------------------

Throughout the 6.4 information deliverables: The specification for the DATEformat values are not consistent.

Correct specification for DATEformat values:

DATEformat= dateformatnum


The /DATEformat parameter selects the format you want to use to
display
dates.


The dateformatnum
variable can range from 1 to 7. The initial
value is 1.


The number values specify the following formats:

1 MM/DD/YYYY

2 DD-MM-YYYY

3 YYYY-MM-DD

4 DD.MM.YYYY

5 YYYY.MM.DD

6 YYYY/MM/DD

7 DD/MM/YYYY

Incorrect specification for DATEformat values:

DATEformat= dateformatnum


The /DATEformat parameter selects the format you want to use to
display
dates.


The dateformatnum
variable displays the date in one of the following formats. Select the format number that corresponds to the format you want to use.

The number values specify the following formats:

1 MM/DD/YYYY. This is the default.
2 DD-MM-YYYY

3 YYYY-MM-DD

4 DD.MM.YYYY

5 YYYY.MM.DD