Query output examples

These output examples provide a sample of the text, messages, and process status that displays when using the query commands.

Query 1–SQL Server

Query 1 queries the SQL Server STRINGVM1. Note that it is set up for VSS operations.
Command:
  tdpsqlc query sql
Output:
IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015.
All rights reserved.

Connecting to SQL Server, please wait...

SQL Server Information
----------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Server Version ....................... 10.0.2573 (SQL Server 2008)

Volume Shadow Copy Service (VSS) Information
--------------------------------------------

Writer Name            : SqlServerWriter
Local DSMAgent Node    : STRINGVM1
Remote DSMAgent Node   : 
Writer Status          : Online
Selectable Components  : 4

Completed

Query 2–SQL Database

Query 2 queries SQL Server database, DB1_XIVmini_G_BAS and includes compatibility information.
Command:
tdpsqlc query sql DB1_XIVmini_G_BAS /compat
Output:
IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015.
All rights reserved.

Connecting to SQL Server, please wait...

SQL Server Information
----------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Server Version ....................... 10.0.2573 (SQL Server 2008)

Cluster ............................. No 

SQL Database Information
------------------------

SQL Database Name ........................ DB1_XIVmini_G_BAS
SQL Database Data Space Allocated ........ 3,145,728
SQL Database Data Space Used ............. 1,376,256
SQL Database Log Space Allocated ......... 2,097,152
SQL Database Log Space Used .............. 393,216
SQL Database Compatibility level.......... 100
SQL Database Options ..................... 

Completed

Query 3–TDP (Legacy)

Query 3 queries Data Protection for SQL Server for configuration file information. Note that this configuration is for legacy operations only as BACKUPDESTination TSM, BACKUPMETHod LEGACY, and the LOCALDSMAgentnode and REMOTEDSMAgentnode are not set.
Command:
tdpsqlc query tdp
Output:
IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015.
All rights reserved.

Data Protection for SQL configuration settings
---------------------------------------------------

BACKUPDESTination ......................... TSM
BACKUPMETHod .............................. LEGACY
BUFFers ................................... 3
BUFFERSIze ................................ 1024
DATEformat ................................ 1
DIFFESTimate .............................. 20
FROMSQLserver ............................. 
LANGuage .................................. ENU
LOCALDSMAgentnode ......................... 
LOGFile ................................... tdpsql.log
LOGPrune .................................. 60
NUMBERformat .............................. 1
REMOTEDSMAgentnode ........................ 
SQLAUTHentication ......................... INTegrated
SQLBUFFers ................................ 0
SQLBUFFERSIze ............................. 1024
SQLCOMPression .............................No
SQLSERVer ................................. STRINGVM1
STRIPes ................................... 1
TIMEformat ................................ 1

Completed

Query 4 – TDP (VSS)

Query 3 queries Data Protection for SQL for configuration file information. Note that this configuration is set for VSS operations as BACKUPDESTination LOCAL, BACKUPMETHod VSS, and the LOCALDSMAgentnode and REMOTEDSMAgentnode options are set.
Command:
tdpsqlc query tdp
Output:
IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015.
All rights reserved.

Data Protection for SQL configuration settings
---------------------------------------------------

BACKUPDESTination ......................... LOCAL
BACKUPMETHod .............................. VSS
BUFFers ................................... 3
BUFFERSIze ................................ 1024
DATEformat ................................ 1
DIFFESTimate .............................. 20
FROMSQLserver ............................. 
LANGuage .................................. ENU
LOCALDSMAgentnode ......................... STRINGVM1
LOGFile ................................... tdpsql.log
LOGPrune .................................. 60
NUMBERformat .............................. 1
REMOTEDSMAgentnode ........................ 
SQLAUTHentication ......................... INTegrated
SQLBUFFers ................................ 0
SQLBUFFERSIze ............................. 1024
SQLCOMPression .............................No
SQLSERVer ................................. STRINGVM1
STRIPes ................................... 1
TIMEformat ................................ 1

Completed

Query 5 – Tivoli Storage Manager Types

Query 5 queries the Tivoli® Storage Manager server for the types of backup objects from all databases, including both active and inactive objects.
Command:
tdpsqlc query tsm * /all
Output:
IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015.
All rights reserved.

Connecting to TSM Server as node 'STRINGVM1_SQL'...

Querying TSM Server for Backups ....

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ DB1_XIVmini_G_BAS
Backup Method     ........................ VSS 
Backup Location   ........................ Srv
Backup Object Type ....................... full
Backup Object State ...................... Inactive
Backup Creation Date / Time .............. 09/23/2013 06:23:14
Backup Size .............................. 5.00 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... No
Database Object Name ..................... 20130923062314
Assigned Management Class ................ DEFAULT

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ DB1_XIVmini_G_BAS
Backup Method     ........................ VSS 
Backup Location   ........................ Srv
Backup Object Type ....................... full
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/23/2013 06:39:31
Backup Size .............................. 5.00 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... No
Database Object Name ..................... 20130923063931
Assigned Management Class ................ DEFAULT

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ DB1_XIVmini_G_BAS
Backup Method     ........................ VSS 
Backup Location   ........................ Loc
Backup Object Type ....................... full
Backup Object State ...................... Inactive
Backup Creation Date / Time .............. 09/23/2013 06:41:14
Backup Size .............................. 5.00 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... Yes
Database Object Name ..................... 20130923064114
Assigned Management Class ................ DEFAULT
Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ DB1_XIVmini_G_BAS
Backup Method     ........................ VSS 
Backup Location   ........................ Loc
Backup Object Type ....................... full
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/23/2013 06:45:57
Backup Size .............................. 5.00 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... Yes
Database Object Name ..................... 20130923064557
Assigned Management Class ................ DEFAULT

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ DB1_XIVmini_G_BAS
Backup Method     ........................ Lgcy
Backup Location   ........................ Srv
Backup Object Type ....................... Full     
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/23/2013 06:31:04
Backup Size .............................. 2.08 MB
SQL Compressed ........................... No
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Database Object Name ..................... 20130923063104\00001AC4
Number of stripes in backup object ....... 1
Assigned Management Class  ............... DEFAULT

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ model
Backup Method     ........................ VSS 
Backup Location   ........................ Srv
Backup Object Type ....................... full
Backup Object State ...................... Inactive
Backup Creation Date / Time .............. 09/23/2013 06:23:14
Backup Size .............................. 3.75 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... No
Database Object Name ..................... 20130923062314
Assigned Management Class ................ DEFAULT
Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ model
Backup Method     ........................ VSS 
Backup Location   ........................ Srv
Backup Object Type ....................... full
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/23/2013 06:43:11
Backup Size .............................. 3.75 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... No
Database Object Name ..................... 20130923064311
Assigned Management Class ................ DEFAULT

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ model
Backup Method     ........................ VSS 
Backup Location   ........................ Loc
Backup Object Type ....................... full
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/23/2013 06:45:58
Backup Size .............................. 4.00 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... No
Database Object Name ..................... 20130923064558
Assigned Management Class ................ DEFAULT

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ model
Backup Method     ........................ Lgcy
Backup Location   ........................ Srv
Backup Object Type ....................... Full     
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/23/2013 06:31:05
Backup Size .............................. 2.08 MB
SQL Compressed ........................... No
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Database Object Name ..................... 20130923063105\00001AC4
Number of stripes in backup object ....... 1
Assigned Management Class  ............... DEFAULT

Completed

Query 6–Tivoli Storage Manager Database

Query 6 queries the Tivoli Storage Manager server for database netapp_db2, and displays all of its active backup objects by default.
Command:
tdpsqlc query tsm model
Output:
IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015.
All rights reserved.

Connecting to TSM Server as node 'STRINGVM1_SQL'...

Querying TSM Server for Backups ....

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ model
Backup Method     ........................ VSS 
Backup Location   ........................ Srv
Backup Object Type ....................... full
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/23/2013 06:43:11
Backup Size .............................. 3.75 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... No
Database Object Name ..................... 20130923064311
Assigned Management Class ................ DEFAULT

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ model
Backup Method     ........................ VSS 
Backup Location   ........................ Loc
Backup Object Type ....................... full
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/23/2013 06:45:58
Backup Size .............................. 4.00 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... No
Database Object Name ..................... 20130923064558
Assigned Management Class ................ DEFAULT

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ model
Backup Method     ........................ Lgcy
Backup Location   ........................ Srv
Backup Object Type ....................... Full     
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/23/2013 06:31:05
Backup Size .............................. 2.08 MB
SQL Compressed ........................... No
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Database Object Name ..................... 20130923063105\00001AC4
Number of stripes in backup object ....... 1
Assigned Management Class  ............... DEFAULT

Completed

Query 7–Tivoli Storage Manager Database

Query 7 queries the Tivoli Storage Manager server for information on database netapp_db2 Group-type backup objects.
Command:
tdpsqlc query tsm netapp_db2 Group=*
Output:
IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015.
All rights reserved.

Connecting to TSM Server as node 'STRINGVM1_SQL'...

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ netapp_db2
Backup Method     ........................ Lgcy
Backup Location   ........................ Srv
Backup Object Type ....................... Group    
SQL Group Logical Name ................... PRIMARY
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/27/2013 08:23:58
Backup Size .............................. 2.08 MB
SQL Compressed ........................... No
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Database Object Name ..................... 20130927082358\00001A4C
Number of stripes in backup object ....... 1
Assigned Management Class  ............... DEFAULT

Query 8 –Tivoli Storage Manager Database

Query 8 displays both active and inactive full backup objects of database Test1. In addition, file information is requested.
Command:
tdpsqlc q tsm DB1_XIVmini_G_BAS full /fileinfo /all
Output:
IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015.
All rights reserved.

Connecting to TSM Server as node 'STRINGVM1_SQL'...

Querying TSM Server for Backups ....

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ DB1_XIVmini_G_BAS
Backup Method     ........................ VSS 
Backup Location   ........................ Srv
Backup Object Type ....................... full
Backup Object State ...................... Inactive
Backup Creation Date / Time .............. 09/23/2013 06:23:14
Backup Size .............................. 5.00 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... No
Database Object Name ..................... 20130923062314
Assigned Management Class ................ DEFAULT

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ DB1_XIVmini_G_BAS
Backup Method     ........................ VSS 
Backup Location   ........................ Srv
Backup Object Type ....................... full
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/23/2013 06:39:31
Backup Size .............................. 5.00 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... No
Database Object Name ..................... 20130923063931
Assigned Management Class ................ DEFAULT

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ DB1_XIVmini_G_BAS
Backup Method     ........................ VSS 
Backup Location   ........................ Loc
Backup Object Type ....................... full
Backup Object State ...................... Inactive
Backup Creation Date / Time .............. 09/23/2013 06:41:14
Backup Size .............................. 5.00 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... Yes
Database Object Name ..................... 20130923064114
Assigned Management Class ................ DEFAULT
Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ DB1_XIVmini_G_BAS
Backup Method     ........................ VSS 
Backup Location   ........................ Loc
Backup Object Type ....................... full
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/23/2013 06:45:57
Backup Size .............................. 5.00 MB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... Yes
Database Object Name ..................... 20130923064557
Assigned Management Class ................ DEFAULT

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ DB1_XIVmini_G_BAS
Backup Method     ........................ Lgcy
Backup Location   ........................ Srv
Backup Object Type ....................... Full     
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/23/2013 06:31:04
Backup Size .............................. 2.08 MB
SQL Compressed ........................... No
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Database Object Name ..................... 20130923063104\00001AC4
Number of stripes in backup object ....... 1
Assigned Management Class  ............... DEFAULT
SQL Server Version ....................... 10.0.2573 (SQL Server 2008)
Cluster .................................. No 
DP Version ............................... 6.4.0.0
SQL Database Compatibility level.......... 100
SQL Database Data Space Allocated ........ 3,145,728
SQL Database Data Space Used ............. 1,376,256
SQL Database Log Space Allocated ......... 2,097,152
SQL Database Log Space Used .............. 344,064
SQL Database Options ..................... 

SQL Group Logical Name ................... PRIMARY
SQL Group Space Allocated ................ 3,145,728
SQL Group Space Used ..................... 1,376,256
SQL File  Logical Name ................... DB1_XIVmini_G_BAS
SQL File  Physical Name .................. G:\SQLSERVER\DB1_XIVmini_G_BAS\DB1_XIVmini_G_BAS.mdf
SQL File  Space Allocated ................ 3,145,728
SQL File  Space Used ..................... 1,376,256

SQL Group Logical Name ................... TRANSACTION LOG
SQL Group Space Allocated ................ 2,097,152
SQL Group Space Used ..................... 344,064
SQL File  Logical Name ................... DB1_XIVmini_G_BAS_log
SQL File  Physical Name .................. G:\SQLSERVER\DB1_XIVmini_G_BAS\DB1_XIVmini_G_BAS_log.ldf
SQL File  Space Allocated ................ 2,097,152

Completed

Query 9 – Tivoli Storage Manager types on AlwaysOn node

Query 9 queries the Tivoli Storage Manager server for the types of backup objects from all standard databases that are backed up to the AlwaysOn node, including both active and inactive objects.
Command:
tdpsqlc query TSM * /all /querynode=alwayson
Output:
C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc query TSM * /all /querynode=alwayson

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015. All rights reserved.

Connecting to TSM Server as node 'c64'...

Querying TSM Server for Backups ....

Backup Object Information
-------------------------

SQL Server Name   ........................ hkgroup
SQL Database Name ........................ hkaagdb
Backup Method     ........................ VSS
Backup Location   ........................ Loc
Backup Object Type ....................... full
Backup on Secondary Replica .............. No
Backup Object State ...................... Active
Backup Creation Date / Time .............. 06/11/2013 10:18:11
Backup Size .............................. 3.12 GB
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... Yes
Database Object Name ..................... 20130611101811
Assigned Management Class ................ DEFAULT