17 lines
459 B
SQL
17 lines
459 B
SQL
SELECT
|
|
database_name,
|
|
backup_start_date,
|
|
backup_finish_date,
|
|
CAST(backup_size / 1024.0 / 1024 AS DECIMAL(18, 2)) AS BackupSizeMB,
|
|
CASE
|
|
WHEN compressed_backup_size IS NOT NULL
|
|
THEN CAST(compressed_backup_size / 1024.0 / 1024 AS DECIMAL(18, 2))
|
|
ELSE NULL
|
|
END AS CompressedBackupSizeMB
|
|
FROM
|
|
msdb.dbo.backupset
|
|
WHERE
|
|
type = 'L'
|
|
AND database_name='arizonarep'
|
|
ORDER BY
|
|
backup_start_date DESC; |