Listare backup-uri efectuate pe un server MSSQL

Situatie

Mai jos este un script ce returneaza backup-urile efectuate pe un server MSSQL, iar pentru aceste backup-uri afiseaza cateva detalii, cum ar fi: data de start si data de sfarsit, calea in care a fost salvat, numele bazei la care a fost facut backup, etc.

Solutie

SELECT DISTINCT

[backup_set_id],

[server_name] = LEFT([server_name], 15),

[database_name] = LEFT([database_name], 20),

[backup_start_date] = CONVERT( VARCHAR(25), [backup_start_date], 121),

[backup_finish_date] = CONVERT( VARCHAR(25), [backup_finish_date], 121),

[backup_duration_sec] = DATEDIFF([ss], [backup_start_date], [backup_finish_date]),

[backup_duration_min] = DATEDIFF([mi], [backup_start_date], [backup_finish_date]),

[backup_size],

[physical_device_name]

FROM [msdb].[dbo].[backupset] AS [bs](nolock)

INNER JOIN [msdb].[dbo].[backupmediafamily] AS [bmf](nolock) ON [bs].[media_set_id] = [bmf].[media_set_id]

WHERE [backup_start_date] BETWEEN DATEADD([dd], -2, GETDATE()) AND DATEADD([dd], 0, GETDATE())

ORDER BY 3

Tip solutie

Permanent

Follow Us