Select B.backup_start_date, B.backup_finish_date, B.database_name as Nome_database, C.physical_device_name as
backup_file_used_for_restore
From msdb..backupset B
INNER JOIN msdb..backupmediafamily C ON
B.media_set_id =
C.media_set_id
Order by B.backup_start_date DESC
Nenhum comentário:
Postar um comentário