SQL Check Database Restore Start Date

We have seen the behavior in SSMS that nothing happens when we go to Tasks/Restore/Database. It means that the backup/restore history for the database is very long, and the wizard will take longer to come up since it reads the entire history first. We need to truncate the history. We can run the script below to determine the backup start date.

1
2
3
SELECT TOP 1 backup_start_date AS 'BackUp Start Date'
FROM msdb.dbo.backupset WITH (NOLOCK)
ORDER BY backup_set_id ASC

TIP: If we dont want to do the truncation for now, the quick workaround for this issue will be to go to Databases/Restore Database...