February 21, 2011 at 12:35 pm
Hi All,
I was wondering if there is any way of finding out who and when a job has been deleted in SQL Server 2000 and Server 2005 please.
February 21, 2011 at 3:25 pm
Do you happen to have an audit trigger in your sysjobs of the msdb database? If not, then there is no way of knowing.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
March 18, 2011 at 2:00 pm
Witch-hunt anyone? If you have backups of your msdb database you can restore those starting with your oldest backup in chronological order to a non-critical instance as a database with a different name and see when it disappeared. This method won't tell you who deleted it but it will give you a range of time as to when it disappeared.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply