SQL Server Database Information

[cyberdidj]

Help Required, Need to create a query that will extract data on all Databases on a server with the following information :- Database Name, size, location, backup filename, size, location, date of Last Backup, log file name, size, location, date of last log file.

[Claire]

You could go to msdb database and refer to all these system tables

1.backupfile
2.backupmediafamily
3.backupmediaset
4.backupset

[cyberdidj]

Thanks, will give it a try.