what is the command to find last backup succesful

[nikki]

Hi Team,

What is the command in tsm to find last backup....
coz iam typing
q event * * begind=-300 begint=12:00 endd=today node=nodename

its showing me backup is missed....
What is the command to find last backup successfull...Please help me..asap
Cheers,
Nikki

 

[yampam]

select END_TIME from summary where activity='BACKUP' and SUCCESSFUL='YES' and ENTITY='NODE_NAME'

 

[nikki]

yampam,

I didnt get can you please type the command....Please..

Cheers,
Nikki

 

[nikki]

can anyone help me please

 

[[email protected]]

Hi Nikki,

If it is scheduled backups then

q event * * will shows completed,started ,failed, missed, inprogress and future.

Here u can find the last completed job.

Note: Backups without schedules are not listed by this q event cmd

Cheers,
Raj.

 

[nikki]

when i type this iam getting missed ....so i want to know the last backup for the node.......

 

[nikki]

q event * * begind=-1000 begint=17:00 endd=today node=abc
iam find missed so please let me know the command

 

[bully]

Use q filespace nodename f=d

 

[nikki]

Iam getting this error
Use q filespace nodename f=d

ANR2034E QUERY FILESPACE: No match found using this criteria.
ANS8001I Return code 11.

 

[bully]

Iam getting this error
Use q filespace nodename f=d

ANR2034E QUERY FILESPACE: No match found using this criteria.
ANS8001I Return code 11.

Nodename

q filespace (nodename is the name from the client) F=D

for ex. q filespace mynode f=d

 

[nikki]

yes i did it i got the error....is there any other command....

 

[[email protected]]

q filespace (nodename is the name from the client) F=D

for example q filespace nikki F=D

if the node name is nikki.

Regards,
Raj.

 

[nikki]

ANR2034E QUERY FILESPACE: No match found using this criteria.
ANS8001I Return code 11.

 

[nikki]

moon buddy can you please tell me the command

 

[bully]

if nothing matched, the client has no data backed up ever.

 

[BBB]

If you are running "q filespace <nodename> F=D" where you are replacing <nodename> with your actual node's name, and you are getting the above error, that means your node has never backed anything up.

 

[nikki]

Yes it as never been backed..everytime it miss the backup schedule what may be the reason and which is the command to investigate more.......

 

[pradeep_itengineer]

first confirm that the scheduled backup is missed or failed, if missed than schedule not start, need to check from the TSM DB server side (see the activity logs) but if failed than first point to see the TSM client logs(dsmerror.log and dsmsched.log).

Thanks,
Pradeep

 

[umur]

it looks like it has never been backed up. why don't you log in to a server, start BA client and try to see if there is any file when you select restore?

While at it, you should also check if there is a scheduler service running on the machine.

 

[ttrinh7975]

nikki-

If TSM client configured, check the dsmsched and dsmerror log. If the back up missed.
But if the client never have been backup. Start TSM GUI, configure and fire off a backup.

Good Luck - Cheer...