• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

[TSM] someone knows an optimized way of searching for a file to restore in TSM DB?

I have a TSM installation that is 14 years old, therefore I have some backed up data which is quite old, and the filesystem structure has changed a few times since it was first backed up.

Now I have to restore a file namexxx.ext, from 9 years ago. The problem is that the original location of the file is not present anymore in the actual server.

I have tried doing "query backup" commands to no avail.
What i need is some way to do a search for the filename that I ant to restore, whithout having to specify the whole filename path (fileset).

basically some tipe of select "namexxx.ext" from filenames

Thanks in advance.
0
Carlos Ijalba
Asked:
Carlos Ijalba
1 Solution
 
woolmilkporcCommented:
You can run the following query, but you should at least know the name of the node from which the file was backed up, otherwise the query will run quite a while.

SELECT NODE_NAME, FILESPACE_NAME, HL_NAME, LL_NAME -
 from BACKUPS -
   where NODE_NAME='NODENAME' and LL_NAME like 'Name%.ext'

FILESPACE_NAME, HL_NAME and LL_NAME together form the full file path.

NODENAME is the UPPERCASE (!) name of the node.

Instead of 'Name%.ext' you can also use something like '%Name%' or '%Name%.ex%'.

Case matters, so if you're unsure specify only lowercase letters and use something like this:

SELECT NODE_NAME, FILESPACE_NAME, HL_NAME, LL_NAME -
 from BACKUPS -
   where NODE_NAME='NODENAME' and lower(LL_NAME) like 'name%.ext'
0
 
Carlos IjalbaSenior SysadminAuthor Commented:
Thanks  woolmilkporc, spot on, as usual!

I will define the select as a script in TSM, because it surely will  be handy on the future.

Best Regards.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now