How to show all backups of a Database in MSSQL

To show all backups of a Database in MSSQL you can use the following snippet.
This snippet will show you every path even if the backup does not exist anymore.

Sample MSSQL

SELECT Distinct physical_device_name AS [BackupPath] FROM msdb.dbo.backupmediafamily

Please Share us:
Please rate this snippet

One thought on “How to show all backups of a Database in MSSQL

Leave a Reply