December 26, 2005 at 12:19 am
How can we recover a deleted job? Is it possible at all?
December 26, 2005 at 8:52 am
They are stored in msdb. You can restore a previous backup of MSDE and get the information from sysjobs and sysjobsteps.
Note: You do not need to overwrite msdb, nor is it recommended. Restore msdb as a different name ot recover the data.
December 26, 2005 at 8:39 pm
Thank you. This is helpful, but can a deleted job be recovered from the msdb transaction logs?
December 27, 2005 at 9:29 am
The answer is no if the database recovery mode is still set to it's default of 'simple'. If you changed the recovery mode of the database to 'full' and implemented regularly scheduled transaction log backups then yes.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply