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
- SELECT a.name, b.type, b.backup_finish_date AS LastSuccessfulBackup,b.backup_finish_date
- FROM master..sysdatabases a
- LEFT OUTER JOIN msdb..backupset b ON a.name = b.database_name
- ORDER BY a.name, b.type
D means the database backup. L is the transaction log bakcup
Restore history is much more straight forward
- select * from restorehistory
Reference
Viewing Information About Backups http://msdn.microsoft.com/en-us/library/ms188653.aspx
Backup/Restore history http://www.sqlbackuprestore.com/backuprestorehistorytables.htm
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.
ReplyDelete