Letztes Restore-Datum einer Datenbank ermitteln
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
Letztes Backup-Datum einer Datenbank ermitteln
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
Datenbankobjekt finden
Select * From sysobjects Where UPPER(name) like UPPER('%Objektname%') |
Select * From sysobjects Where UPPER(name) like UPPER('%Objektname%')
Kommentare sind geschlossen.