--Getting Database Backup History In SQL Server
SELECT
bs.database_name,
bs.backup_start_date,
bs.backup_finish_date,
bs.server_name,
bs.user_name,
bs.type,
bm.physical_device_name
FROM
msdb.dbo.backupset
AS
bs
INNER
JOIN
msdb.dbo.backupmediafamily
AS
bm
on
bs.media_set_id = bm.media_set_id
No comments:
Post a Comment