Would you show me how to use SMO to find the name of the media of the last
succesful backup via SMO?

I use maintenance plan to do backup.  I need to find the name of the media
(backup file) that was created for the last backup.

thanks,
ktm

I did not get a response to my question.  I am not sure if my question was
not clear enough, or SMO has no support for what I need.  Anyway below is the
query in SQL 2005 that i think can provide the correct device name of the
last backup of a database.  I need an easier way via SMO to find the device
name.

select top 1 database_name, backup_set_id, type, physical_device_name
'DeviceName'
  ,backup_start_date Start, backup_finish_date Finish
  ,is_damaged 'Damaged', has_incomplete_metadata 'Incomplete'
  FROM msdb..backupmediafamily f, msdb..backupset s
where upper(database_name) = 'ADVENTUREWORKS'
and f.media_set_id = s.media_set_id
order by backup_finish_date desc

thanks,
ktm

Show quoteHide quote

Recovery Model Question.
HELP!!! --- From Job tasks to ASP
Moving databases to a different partition
Renaming a diagram in SQL Server Management Studio
WMI and Instance