Extract Backup Details

We need data to be restored from tapes for the object 

“SAMDB. TableToRestore” (Size: 1.12 MB) below are the details:

JOIB ID                                    JOB NAME                                        TIMESTAMP                       

527d95fd0000003d           SAM_PHASE01                                    2014-01-04 05:21:45

To extract above information, we need to login to media server (ciscotdprod-ms1.cisco.com) and fire the below command.

tarajobquery -u administrator -p teradata -L

TARAJOBQUERY is a utility with which we can list out all the JOB details that were launched through TARA. These details will help DIGTeam to find out the media (Tape) easily.

This command needs to be run on the server where TARA is residing, in our case its  “tdsam-ms1.cisco.com”.

-u , -p and –L are the parameters required to display the result (username, password and Listing).