Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 140
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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