The script below retrieves the backupset records. A backup set contains the backup from a single, successful backup operation. RESTORE, RESTORE FILELISTONLY, RESTORE HEADERONLY, and RESTORE VERIFYONLY statements operate on a single backup set within the media set on the specified backup device or devices.
USE msdb ; SELECT backup_start_date , backup_finish_date, CAST(ROUND ((backup_size / 1024 / 1024), 0, 1) AS DECIMAL (18,0)) AS Backup_Size_MB , recovery_model, [type] FROM dbo.backupset WHERE database_name = 'RBD_DB' ORDER BY backup_start_date DESC /* Backup type. Can be: D = Database I = Differential database L = Log F = File or filegroup G =Differential file P = Partial Q = Differential partial Can be NULL. Reference: https://technet.microsoft.com/en-us/library/ms186299(v=sql.110).aspx */
