Check backup in Query Analyzer?

Comments

• Options

  petey Redgate › Posts: 2,358 New member

  September 14, 2006 9:13PM

  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.

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• Options

  Bart430 Posts: 13

  September 15, 2006 9:28AM

  Thanks Pete

  0 · Share on Twitter