msdb.dbo.backupset

This morning I wanted to have a quick look at the backup history of a given database. This I got by this statement

SELECT [backup_start_date] AS 'Start'
,([backup_finish_date]-[backup_start_date]) AS 'Duration'
,(([backup_size]/1024)/1024)/1024 AS 'Size [GB]'
FROM [msdb].[dbo].[backupset]
WHERE [database_name]='my_database' AND [type]='D'
ORDER BY [Start] DESC;

The multiple division by 1024 is to get a clear number.

UNMOUNTABLE_BOOT_VOLUME

A friend of mine have an (very) old notebook running Windows XP, and it came up with this awful message in a Blue Screen:
UNMOUNTABLE_BOOT_VOLUME

The fix was

1. Boot the machine on a installation set (Windows XP CD-ROM)
2. Go to the Recovery Console
3. Run the command "chkdsk c: /r"

The contents of the disk is rescued, but the machine is still due to a replacement...