All Available Backups in MS SQL

In SQL Server 2008, to see all available db backups:

select * from msdb.dbo.backupset