2009-08-18

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.

2009-08-08

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...