Home Forums Article Discussions Article Discussions by Author Discuss content posted by ripg1011 check full recovery dbs have tran log backups RE: check full recovery dbs have tran log backups
DavePeck
SSC Enthusiast
Points: 143
More actions
February 20, 2009 at 9:42 am
#947638
The LEFT JOIN for the derived table in the example from stuart.adair should be on b.database_name (not b.DateLogLastBackedUp):
) b ON a.[name] = b.database_name