Solved

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

Posted on 2015-02-18
2
133 Views
Last Modified: 2015-02-19
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
Comment
Question by:Carlos Ijalba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 68

Accepted Solution

by:
woolmilkporc earned 500 total points
ID: 40617218
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
 
LVL 10

Author Closing Comment

by:Carlos Ijalba
ID: 40618457
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question