I needed to find out if a backup was done, but didn't have the full name of the database because they all have similar names on that server. Here's script to figure that out fast.
select * from msdb.dbo.backupfile
Where logical_name like'%DATABASESEARCHTERM%'
--Where it says DATABASESEARCHTERM just put in something you think is close.
No comments:
Post a Comment