use msdb

select * from sys.sysobjects where xtype='U' and name like ('backup')

backup database master to disk='C:sqllaback.bak'

select * from backupfile

select * from backupfilegroup

select * from backupmediafamily --order by media_set_id desc

select * from backupmediaset order by media_set_id desc

select * from backupset

select * from backupmediafamily where 1=2

select * from restorehistory where 1=2

select * from backupset where 1=2

select * from sys.sysobjects where xtype='U'and name like ('restore')

select * from restorefile

declare @dbname varchar(max)
set @dbname = 'dummy'
select physical_device_name,destination_database_name,restore_date from restorehistory R join backupset B on R.backup_set_id = B.backup_set_id join backupmediafamily C on C.media_set_id=B.media_set_id
where destination_database_name like @dbname
order by restore_date desc

backup database dummy to disk = 'c:dummy.bak'

restore database dummy from disk = 'c:dummy.bak' with replace

==============================================================================

select * from backupmediaset where 1=2

select * from backupset where 1=2

select * from backupmediafamily where 1=2

select * from restorehistory where 1=2

select * from backupset where 1=2

D = Database

I = Database Differential

L = Log

F = File or Filegroup

G = File Differential

P = Partial

Q = Partial Differential

select  b.server_name,b.database_name,
case b.type
when 'D' then 'Database'
when 'I' then 'Database Differential'
when 'L' then 'Log'
when 'F' then 'File or Filegroup'
when 'G' then 'File Differential'
when 'P' then 'Partial'
when 'Q' then 'Partial Differential'
else 'NULL'
end,
c.physical_device_name,
case c.device_type
when 2 then 'DISK'
when 102 then 'DISK'
when 5 then 'TAPE'
when 105 then 'TAPE'
else 'NULL'
end,
b.recovery_model,(b.backup_size/(1024*1024)) as 'Backup size in MB'
from backupset b
join
backupmediafamily c
on (b.media_set_id=c.media_set_id)
where b.database_name like 'testdb'