Offsite backupsets

[jmarquez]

Hi,



I have a TSM server v.5.1.5 on a windows 2000 server. Every weekend the TSM server generates backupsets that we send offsite for disaster recovery purposes.

When the backupsets expires, we want to bring the cartridges onsite for using again as scratch volumes. The problem is that we don't know which TSM command use to see the backupsets that have expired offsite and which tapes we can bring onsite.



Thank you

 

[chad_small]

Backupset volumes can only be tracked with the volume history file. What you will have to do is query the volhist by date (i.e. Q VOLHIST BEGIND=<DATE> ENDD=<DATE> TYPE=BACKUPSET). Generate the list prior to deleting the backupsets. Then give it to the courier to bring back those tapes which fall after the set retention period. You can get more refined with the report by using an SQL script, but either would do.



select b.node_name, b.backupset_name, b.date_time, v.volume_name, b.retention from backupsets b, volhistory v where v.type='BACKUPSET' and b.date_time=v.date_time order by b.date_time



This SQL script will work as long as multiple backupsets were not started at exactly the same time.



Chad Small

TSM Certified Consultant

IBM Global Services

[email protected]