Is there a built in Stored proc that will enum all of the databases on a server and display the last backup time?



Hal Levy
I am here to help you, not do it for you.
That is, unless you hire me. I am looking for work.

__________________
Hal Levy

Hal, sp_databases will lists databases that reside in an instance of Microsoft® SQL Server™ or are accessible through a database gateway.

Regarding last backup time I think there is no system stored procedure but might want to query backupset table on your msdb database.

SELECT [database_name],[backup_finish_date]
FROM [msdb].[dbo].[backupset]

Shahchi, This select statement works with what I wanted-- however i must admit I am having some kid of brain drain at the moment-- perhaps too much time not working.. IN any case...

I need to get only the latest... for each database... so I will work on it further.. thanks for the pointer

Hal Levy
I am here to help you, not do it for you.
That is, unless you hire me. I am looking for work.

Hal, can't you just do a select max, group by ...?

If you need anything more complicated then a correlated subquery is what you need.

rgds
Phil

Phil,

I am trying to get a final requirement on what they want... I think I can use the max.. and they were happy with that-- but they are now saying they might want the last "few"...

Hal Levy
I am here to help you, not do it for you.
That is, unless you hire me. I am looking for work.