CODE SNIPPETS

All the Code Snippets and Samples you need

Microsoft SQL Server

How to show all backups of a Database in MSSQL

ByAdministrator

Jun 16, 2014 , , , , , ,

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

By Administrator

Related Post

Microsoft SQL Server

How to get the current Database and Log Filesize using MSSQL

May 22, 2015 Administrator
Microsoft SQL Server

How to drop Primary Key of a Table using MSSQL

Apr 21, 2015 Administrator
Microsoft SQL Server

How to search stored procedures using MS-SQL

Apr 15, 2015 Administrator
One thought on “How to show all backups of a Database in MSSQL”

Leave a Reply