Solved

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

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

By default, Carbonite Server Backup manages your encryption key for you using Advanced Encryption Standard (AES) 128-bit encryption. If you choose to manage your private encryption key, your backups will be encrypted using AES 256-bit encryption.
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
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…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

752 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