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 |
|
dmaxj
Posting Yak Master
174 Posts |
 Posted - 2010-11-17 : 15:53:54
|
| There used to be a SQL Job that performed full backups for multiple db's. Another DBA decided to split the full backup job into separate full back jobs. He then deleted the old job.I am trying to access the history for the old full backups, but they do not exist because the old job does not show in the jobs list.Is there a way to retrieve the results from the deleted sql job?Regards |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-11-17 : 16:04:07
|
| If you have a backup of the msdb database taken before the job was dropped, you can restore it with a new name and query its sysjobhistory table. Otherwise I think you're SOL. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-11-17 : 16:59:16
|
| A history of actual backups, rather than jobs-run, is available in MSDB tables. Would that do? |
|
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2010-11-17 : 21:04:50
|
| Thanks, Kristen - that is getting to the point. Thank you. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-11-17 : 22:19:13
|
| OK, there is a script for a report of backup history here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300#273265 |
|
|
|
|
|
|
retrieve results from deleted sql jobs