Solved

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

Posted on 2015-02-18
2
125 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
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 9

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

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

680 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