SELECT a.name, B.backup_date FROM dbo.sysdatabases a LEFT OUTER JOIN
(SELECT database_name, MAX(backup_finish_date) backup_date FROM
msdb.dbo.backupset WHERE backup_finish_date <= getdate() and type = 'D'
GROUP BY database_name) B ON a.name = B.database_name ORDER BY
B.backup_date DESC

-----Original Message-----
From: Ligda John
[mailto:mssqldba-ezmlmshield-x64804098.[Email address protected]
Sent: Thursday, May 31, 2007 1:51 PM
To: LazyDBA Discussion
Subject: backup set info query

Hello all.



Can someone show me how to query the system tables for recent backup
info?



Thanks





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





------------------------------------------------------------------------------
"This electronic message transmission contains
confidential or privileged information from Mount
Carmel . The information is intended for use by the
individual or entity named above. If you are not the
intended recipient, be aware that any disclosure,
copying, distribution or use of the contents of this
information is prohibited. If you have received this
electronic transmission in error, please notify us
immediately by telephone (614-234-8700) or by electronic
mail ([Email address protected]
==============================================================================


MS Sql Server LazyDBA home page