great it works ,tanks alot both of you.

what about apex?is there any table that it reads from that?

i need to know it shows the log from where?

i think it is fn_dblog(null, null) .but when i shrink log or bakup full it shows nothing but apex still shows.

is it msdb.dbo.backupset?