Thursday, November 17, 2011

1 Find out Backup & Restore History from MSDB

We can find out Backup & Restore History from below 2 tables in MSDB.

  • backupset: Backup History
  • restorehistory: Restore History.

Below Query list all the database backup history

  1. SELECT, b.type, b.backup_finish_date AS LastSuccessfulBackup,b.backup_finish_date
  2. FROM master..sysdatabases a
  3. LEFT OUTER JOIN msdb..backupset b ON = b.database_name
  4. ORDER BY, b.type

D means the database backup. L is the transaction log bakcupimage

Restore history is much more straight forward

  1. select * from restorehistory



Viewing Information About Backups

Backup/Restore history


  1. Rolex offers fake rolex UK a variety of models, from professional to classic watches, replica rolex datejust Watches to fit any wrist. Choose your favorite model, material, bezel, dial and bracelet, explore the Rolex series, and find the watch that suits you.



SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates