mah_j (9/19/2012)
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?
Never used Apex tools I'm afraid so no idea.....Are you using ApexSQL Log?
I wonder, could it be cached information you're seeing? Maybe re-starting the tool to see if that makes any difference?
Excuse my ignorance but I've never used this tool before.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn