filmov
tv
How to list the last backup stats for all databases in SQL?
Показать описание
How to list the last backup stats for all databases in SQL?
SQL Code:
-------------------------------------------------------------------------------------------------------------------------
PhysicalDeviceName = physical_device_name,
BackupSizeMB = convert(INT,backup_size),
DurationMinutes = duration
ORDER BY DatabaseName
-------------------------------------------------------------------------------------------------------------------------
SQL Code:
-------------------------------------------------------------------------------------------------------------------------
PhysicalDeviceName = physical_device_name,
BackupSizeMB = convert(INT,backup_size),
DurationMinutes = duration
ORDER BY DatabaseName
-------------------------------------------------------------------------------------------------------------------------
1:50:00
0:03:36
0:17:23
0:02:10
0:07:29
0:03:20
0:01:06
0:00:45
0:01:56
0:01:32
0:01:35
0:02:33
0:05:19
0:01:16
0:03:55
0:00:35
0:03:51
0:03:23
0:01:38
0:01:00
0:02:39
0:28:57
0:02:58
0:06:34