use msdb
select
DBRestored = destination_database_name,
RestoreDate = restore_date,
SourceDB = b.database_name,
SourceFile = physical_name,
BackupDate = backup_start_date
from RestoreHistory h join BackupSet b
on h.backup_set_id = b.backup_set_id
join BackupFile f
on f.backup_set_id = b.backup_set_id
order by RestoreDate
It took approx 2 days to get this installed! This is one install where you must read the docs before installing.
Had numerous errors during the install relating to security errors for the TFS user accounts and also, after aborted installs, had to manually delete files to get the install through.
TIP: When you get errors read the msi log files carefully and you should be able to work out why it went wrong.
Had been using the server built into visual studio 2008 but today needed to use IIS but when I went to start I got a weird error message:
Did some googling on this and found that the problem was related to another program using port 80.
Using the tool CurrPorts I was able to see that skype had used port 80 already, e.g.:
To fix open Skype then Tools > Options > Advanced > Connection. Then untick Use Port 80 for incoming connections then re-start Skype.
You can then start IIS as port 80 is free again!
