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

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

Leave a Reply