How to find the backup finish date, the backup size, and the backup start and finish times?
To verify there have been no changes after a restore of a backup file:
NOTE: Take a LiteSpeed backup for Northwind .
1. Open Query Analyzer.
2. USE msdb
3. Run the below query and take note of the data presented:
use msdb
go
SELECT TOP 10 physical_device_name, backup_size, backup_start_date, backup_finish_date, database_name
FROM backupset bs, backupmediafamily bf
WHERE bs.media_set_id = bf.media_set_id
AND backup_start_date > GETDATE() - 1
AND database_name LIKE 'Northwind'
ORDER BY backup_start_date DESC
4. Run a restore of the Northwind DB using the backup set that was just created.
5. Run the query again, taking note of the output. The data for the backup_finish_date should not have changed.
