Thanks, will take that into consideration.

Yes, I agree.5 to 10 minute intervals should be fine. Thanks

@Grant ,

Yes, that was my intention take a chunk of everyday data rows and execute some sql code/agaent job against the table.I am sure the datatable per day will be...

• This reply was modified 4 years ago by  mtz676.
• This reply was modified 4 years ago by  mtz676.

this was mistake.How do I take this post down or mark it as duplicate ?

I am trying to build an extract of backup files(full,diff,log) along with locations(without file names as in the query provided here) usingbackupset and backupmediafamily tables.(past 7 days of days should...

that worked.thanks

Thanks.

Yes I do. I thought you meant after I make progress on that script. Anyways here it is.

SELECT
@@servername [ServerName]
,master.sys.sysdatabases.name [DatabaseName]
,msdb.dbo.backupset.backup_start_date [BACKUP START]
,msdb.dbo.backupmediafamily.physical_device_name[FILE Location]
,CASE
WHEN msdb.dbo.backupset.type = 'D'
THEN 'FULL'
WHEN...

Apologies, I was not clear entirely in my first post.

I got the table result from msdb.dbo.backupset, master.sys.sysdatabases and msdb.dbo.backupmediafamily.

I am trying to draw inference from the results and see the...

Yes, I am trying to draw the inference from the results. If necessary I may need to make changes but not yet there.

Close enough and yes .(excepting the auditors part !) I will post code once I make progress.

Yes, not because I did not want to but because it was unfamiliar and difficult for me to understand. Not denying that.

Thank you anyways.

Thanks for the answer..I had it working using table variables in my script and it worked fine.

Please refer to the code from @ktflash.

I had the code working I broke the existing code to return only 1 value(row/column) and that made it work with the...

Thanks.

If a 3rd party tool takes db backups(full,diff,log) will that information be captured inside sql tables ?