How can we help you today?

How can we help you today?

Check backup in Query Analyzer?

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

Bart430 September 14, 2006 16:13

0

Comments

2 comments

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.

petey September 14, 2006 21:13

0
Thanks Pete

Bart430 September 15, 2006 09:28

0

Add comment

Please sign in to leave a comment.