RESTORE DATABASE BASSISControlCYP
FROM DISK =  'H:\Backups\Complete\BASSISControlCYP_backup_201208170809.bak'
WITH REPLACE,
NORECOVERY,
MOVE 'BASSISControl' TO 'F:\MSSQL\Data\BASSISControlCYP.mdf',
MOVE 'BASSISControl_log' TO 'F:\MSSQL\Log\BASSISControlCYP.ldf'

RESTORE DATABASE BASSISControlCYP
FROM DISK =  'H:\Backups\Differential\BASSISControlCYP_backup_201208200745.bak'
WITH REPLACE,
NORECOVERY,
MOVE 'BASSISControl' TO 'F:\MSSQL\Data\BASSISControlCYP.mdf',
MOVE 'BASSISControl_log' TO 'F:\MSSQL\Log\BASSISControlCYP.ldf'

RESTORE DATABASE BASSISControlCTL
FROM DISK =  'H:\Backups\Complete\BASSISControlCTL_backup_201208170808.bak'
WITH REPLACE,
NORECOVERY,
MOVE 'BASSISControl' TO 'F:\MSSQL\Data\BASSISControlCTL.mdf',
MOVE 'BASSISControl_log' TO 'F:\MSSQL\Log\BASSISControlCTL.ldf'

RESTORE DATABASE BASSISControlCTL
FROM DISK = 'H:\Backups\Differential\BASSISControlCTL_backup_201208200959.bak'
WITH REPLACE,
NORECOVERY,
MOVE 'BASSISControl' TO 'F:\MSSQL\Data\BASSISControlCTL.mdf',
MOVE 'BASSISControl_log' TO 'F:\MSSQL\Log\BASSISControlCTL.ldf'

SELECT 
TOP 100
s.database_name,
CASE s.type
WHEN 'D' THEN 'Full'
WHEN 'I' THEN 'Differential'
WHEN 'L' THEN 'Transaction Log'
END AS BackupType,
CAST(DATEDIFF(second, s.backup_start_date,
s.backup_finish_date) AS VARCHAR(4)) + ' ' + 'Seconds' TimeTaken,
s.backup_start_date,
CAST(s.first_lsn AS VARCHAR(50)) AS first_lsn,
CAST(s.last_lsn AS VARCHAR(50)) AS last_lsn,
m.physical_device_name,
CAST(CAST(s.backup_size / 1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS bkSize,
s.server_name,
s.recovery_model
FROM msdb.dbo.backupset s
INNER JOIN msdb.dbo.backupmediafamily m ON s.media_set_id = m.media_set_id
WHERE s.database_name = DB_NAME() -- Remove this line for all the database
ORDER BY backup_start_date DESC, backup_finish_date
GO

BASSISControlCTL	Differential	0 Seconds	2012-08-20 09:59:03.000
BASSISControlCTL	Differential	0 Seconds	2012-08-20 07:46:09.000
BASSISControlCTL	Full	0 Seconds	2012-08-17 08:08:55.000