The simplest way to obtain the database backup history and the most recent backup information if you are using SQL Server Management Studio (SSMS) as your SQL Server client application is to use the backup and restore events report.
Right-click the database in the SSMS object explorer panel.
From the right-click menu select Reports >> Standard Reports >> Backup and Restore Events.
Or
You can run below command to get the details
SELECT
bs.database_name,
bs.backup_start_date,
bs.backup_finish_date,
bs.server_name,
bs.user_name,
bs.type,
bm.physical_device_name
FROM msdb.dbo.backupset AS bs
INNERJOIN msdb.dbo.backupmediafamily AS bm on bs.media_set_id = bm.media_set_id
The simplest way to obtain the database backup history and the most recent backup information if you are using SQL Server Management Studio (SSMS) as your SQL Server client application is to use the backup and restore events report.
Right-click the database in the SSMS object explorer panel.
From the right-click menu select Reports >> Standard Reports >> Backup and Restore Events.
Or
You can run below command to get the details
SELECT bs.database_name, bs.backup_start_date, bs.backup_finish_date, bs.server_name, bs.user_name, bs.type, bm.physical_device_name FROM msdb.dbo.backupset AS bs INNER JOIN msdb.dbo.backupmediafamily AS bm on bs.media_set_id = bm.media_set_id.