SQL Server Performance Forum – Threads Archive

Tracking users in 2005

is there any way in SQL Server 2005 to find out who cancelled/disabled the maintenance job(i.e backup jobs)?
Someone at work diabled the jobs and i am trying to find out who did tht thanks

I don’t think this kind of history is stored in msdb anywhere. first order of business would be to lock the server down so this doesn’t happen again. [<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />] <hr noshade size="1">www.elsasoft.org

In SQL Server 2005, you can use DDL triggers to track a lot of similar activity, but you have to write your own code. This information is not stored by default. ————————————————————–
Brad M. McGehee, SQL Server MVP
Technical Editor/Moderator www.SQL-Server-Performance.Com
Director of DBA Education for www.Red-Gate.Com
www.sqlbrad.com
www.sqlHawaii.com

As explained there is no way to retrieve such information, either you have to use third party tools to chekc the transaction log for events (which is a laborious job to perform), also you might need to deploy such DDL triggers which is available since SP2 for SQL Server. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

You can take the help of default trace which keep 5 files of 20MB each size…
These files will be overwritten as needed….if it is highly active server then it is too late…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>