No Sir..Because I am fetching file1.txt details from another server.

We have ALWAYSON configurtion between primary and secondary. The backup is native SQL backup, FULL, Differential and TLOG.When it is active on primary the backups runs on primary when it...

Hi Beatrix,
We want those records for generating monthly backup report....client is not satisfied to run the backup report on both servers...That's why we are looking for some way to...

Ok thank you.. In that case,how can we get those backup information on primary server itself?
Is there any other way apart from querying backupset table on secondary server??

It's mirroring failover server

Hi Steve,
Yes .msdb.dbo.backupset table.Actually we are generating backup report on primary server using backupset table...Sometimes backup happens on standby server which get stored in backupset table on standby itself ...