Query positional parameters

Positional parameters immediately follow the query command and precede the optional parameters.

Specify one of the following when you issue a Data Protection for SQL Server query command:
Query SQL *|dbname,...
This parameter displays information about the current SQL Server. The dbname variable specifies databases on the current SQL Server to display information about.
When you query an SQL Server, the following information is included:
  • Server name
  • Database name
  • Database data space allocated
  • Database space that is used
  • Database log space allocated
  • Database log space used
  • Database options set (SELECT INTO / BULK COPY, TRUNCATE LOG ON CHECKPOINT)
If you specify the /COMPATibilityinfo parameter:
  • Server version
  • Server clustering state
  • Database compatibility level
Query TDP
This parameter displays the Data Protection for SQL Server name and version information and the contents of the current Data Protection for SQL Server configuration file.
Query TSM *|dbname,...
This parameter displays the Tivoli® Storage Manager API and Tivoli Storage Manager server version information. The dbname variable names the specified databases from the current SQL Server that have backup objects on the current Tivoli Storage Manager server and node. No name is displayed if specified objects do not exist as backup objects in the SQL Server database. Use the dbname wildcard option to display information about all of the backup objects of one or more SQL Server databases.
When you query any backup object by using dbname parameter, the following information is included:
  • SQL Server name
  • SQL Server database name
  • Backup object type
  • Backup object active/inactive state
  • Backup object Data Protection for SQL Server creation date and time
  • Backup object Data Protection for SQL Server size
  • Data Protection for SQL Server backup-object object name
  • For legacy backups, whether the integrity of database and log files is verified by checksum processing
  • SQL compressed
  • Backup compressed
  • Backup encryption type
  • Backup deduplicated
  • Backup method
  • Backup location
  • Backup on secondary replica
  • Number of data stripes in backup object
  • For VSS only, whether the backup supports Instant Restore
The following is included if you specify the /COMPATibilityinfo parameter:
  • SQL Server version
  • SQL Server clustering state
  • Data Protection for SQL Server version that created the backup object
  • SQL Server database compatibility level
  • SQL Server database data space allocated
  • SQL Server database data space used
  • SQL Server database log space allocated
  • SQL Server database log space used
  • SQL Server database options
Note:
  • You can also determine which backup objects to display through the query TSM optional parameters /active and /all.
  • No information is displayed if no backup objects for a specified SQL Server database exist.
FIle=*|logicalfilename,...
This parameter displays information about file backup objects of one or more SQL Server databases from the current SQL Server that are on the current Tivoli Storage Manager server and node.
Full
This parameter displays information about full backup objects of one or more SQL Server databases from the current SQL Server that are on the current Tivoli Storage Manager server and node.
Difffull
This parameter displays information about differential backup objects of one or more SQL Server databases from the current SQL Server that are on the current Tivoli Storage Manager server and node.
Group=*| groupname,...
This parameter displays information about one or more group backup objects of one or more SQL Server databases from the current SQL Server that are on the current Tivoli Storage Manager server and node.
Log=*| logobjectname,...
This parameter displays information about one or more log backup objects of one or more SQL Server databases from the current SQL Server that are on the current Tivoli Storage Manager server and node. The logobjectname variable specifies which log backup objects to display information about. Use * as a wildcard character in logobjectname to replace zero or more characters for each occurrence. Specifying only the wildcard character indicates all log backup objects for the SQL Server databases.
Set=*| setobjectname,...
This parameter displays information about one or more set backup objects of one or more SQL Server databases from the current SQL Server that are on the current Tivoli Storage Manager server and node. The setobjectname variable specifies which set backup objects to display information about. Use * as a wildcard character in setobjectname to replace zero or more characters for each occurrence. Specifying only the wildcard character indicates all set backup objects for the SQL Server databases.
Types
(Legacy backups only) This parameter displays a summary list of the backup objects by backup type, of one or more SQL Server databases from the current SQL Server that are on the current Tivoli Storage Manager server and node. Only backup types with one or more backup objects are displayed. If the /all optional parameter is specified, the number of inactive backup objects is included. You cannot specify either the /compatibility or the /fileinfo optional parameter with the types parameter.