this and that SQL Server

select destination_database_name,max(restore_date) as letztes_Wiederherstellungsdatum from msdb..restorehistory
where destination_database_name='Datenbankname'
group by destination_database_name

select destination_database_name,max(restore_date) as letztes_Wiederherstellungsdatum from msdb..restorehistory where destination_database_name='Datenbankname' group by destination_database_name

select database_name,max(backup_finish_date) as letztes_Backupdatum from msdb..backupset
where database_name='Datenbankname'
group by database_name

select database_name,max(backup_finish_date) as letztes_Backupdatum from msdb..backupset where database_name='Datenbankname' group by database_name

Select * From sysobjects Where UPPER(name) like UPPER('%Objektname%')

Select * From sysobjects Where UPPER(name) like UPPER('%Objektname%')