Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Justu
Starting Member
4 Posts |
 Posted - 2011-01-09 : 19:58:47
|
| Hi Friends,Can somebody please let me know how every database that was backed up.Thanks |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-01-10 : 00:07:00
|
| this might help youSELECT database_name, physical_device_name, backup_start_date FROM msdb.dbo.backupset a INNER JOIN msdb.dbo.backupmediafamily b ON a.media_set_id = b.media_set_id ORDER BY a.backup_start_date DESC |
 |
|
|
Justu
Starting Member
4 Posts |
Posted - 2011-01-10 : 02:14:02
|
| Thank you very mich Ahmed. |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-01-10 : 04:47:05
|
| you are welcome |
|
|
|
|
|
|
Backup location