Inactivate output examples
These output examples provide a sample of the text, messages, and process status that displays when using the inactivate command.
The following operation explicitly deactivates database
backup objects. Once a backup object is deactivated,
it will expire automatically according to retention policy. In this
case, the objects were backed up from a different
SQL Server. First, a query is performed to display
status information such as active state and backup date.
- Command:
-
tdpsqlc query tsm DB1_XIVmini_G_BAS,model * /fromsqlserv=STRINGVM1\STRINGVM1 - Output:
-
IBM Tivoli Storage Manager for Databases Data Protection for Microsoft SQL Server Version 7, Release 1, Level 3.0 (C) Copyright IBM Corporation 1998, 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 ........................ Lgcy Backup Location ........................ Srv Backup Object Type ....................... Full Backup Object State ...................... Active Backup Creation Date / Time .............. 03/23/2014 06:31:04 Backup Size .............................. 3.35 MB SQL Compressed ........................... No Backup Compressed ........................ No Backup Encryption Type ................... None Backup Client-deduplicated ............... No Database Object Name ..................... 20140323063104\00001AC4 Number of stripes in backup object ....... 1 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 .............. 03/20/2014 05:35:14 Backup Size .............................. 3.35 MB SQL Compressed ........................... No Backup Compressed ........................ No Backup Encryption Type ................... None Backup Client-deduplicated ............... No Database Object Name ..................... 20140320053514\00001AC4 Number of stripes in backup object ....... 1 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 .............. 03/19/2014 07:01:39 Backup Size .............................. 3.35 MB SQL Compressed ........................... No Backup Compressed ........................ No Backup Encryption Type ................... None Backup Client-deduplicated ............... No Database Object Name ..................... 20140319070139\00001AC4 Number of stripes in backup object ....... 1 Assigned Management Class ............... DEFAULTBackup 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 .............. 03/23/2014 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 ..................... 20140323063105\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 ........................ Lgcy Backup Location ........................ Srv Backup Object Type ....................... Full Backup Object State ...................... Active Backup Creation Date / Time .............. 03/19/2014 11:26:15 Backup Size .............................. 2.08 MB SQL Compressed ........................... No Backup Compressed ........................ No Backup Encryption Type ................... None Backup Client-deduplicated ............... No Database Object Name ..................... 20140319112615\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 ........................ Lgcy Backup Location ........................ Srv Backup Object Type ....................... Full Backup Object State ...................... Active Backup Creation Date / Time .............. 03/17/2014 01:15:48 Backup Size .............................. 2.08 MB SQL Compressed ........................... No Backup Compressed ........................ No Backup Encryption Type ................... None Backup Client-deduplicated ............... No Database Object Name ..................... 20140317011548\00001AC4 Number of stripes in backup object ....... 1 Assigned Management Class ............... DEFAULT Completed
The user then decides to deactivate all DB1_XIVmini_G_BAS database
objects older than two days (older than March 23),
of which there are two.
- Command:
-
tdpsqlc inactivate DB1_XIVmini_G_BAS * /fromsqlserv=STRINGVM1 /olderthan=2 - Output:
-
IBM Tivoli Storage Manager for Databases Data Protection for Microsoft SQL Server Version 7, Release 1, Level 3.0 (C) Copyright IBM Corporation 1998, 2015. All rights reserved. Starting Sql database backup inactivation... Querying Tivoli Storage Manager server for a list of database backups,please wait... Inactivating full backup DB1_XIVmini_G_BAS Inactivating log backup DB1_XIVmini_G_BAS\20140320053514\00001AC4 Inactivating full backup DB1_XIVmini_G_BAS Inactivating log backup DB1_XIVmini_G_BAS\20140319070139\00001AC4 Total database backups inspected: 2 Total database backups requested for inactivation: 2 Total database backups inactivated: 2 Total database skipped: 0 Elapsed processing time: 2.18 Secs
Another Tivoli® Storage
Manager query displays the current status of these backup objects
using the /all parameter; a full and a log backup
of test1 are now both inactive.
- Command:
-
tdpsqlc query tsm test1 /fromsqlserv=STRINGVM1 /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 1998, 2015. All rights reserved. Backup Object Information ------------------------- SQL Server Name ........................ STRINGVM1 SQL Database Name ........................ DB1_XIVmini_G_BAS Backup Object Type ....................... Log Backup Object State ...................... Inactive Backup Creation Date / Time .............. 03/20/2014 05:35:14 Backup Size .............................. 3,349 Database Object Name ..................... 20140320053514\00001AC4 Number of stripes in backup object ....... 1 SQL Server Name ........................ STRINGVM1 SQL Database Name ........................ DB1_XIVmini_G_BAS Backup Object Type ....................... Full Backup Object State ...................... Inactive Backup Creation Date / Time .............. 03/19/2014 07:01:39 Backup Size .............................. 3,349 Database Object Name ..................... 20140320053514\00001AC4 Number of stripes in backup object ....... 1