Check backup in Query Analyzer?

Bart430

Is there way I can run a scrip in Query Analyzer to see when the last backup was?

petey

SELECT TOP 1 * FROM msdb..backupset WHERE database_name = 'pubs' AND type = 'D' ORDER BY backup_finish_date DESC

Change database_name and type as required. See Books Online for possible values for type.

Bart430

Thanks Pete