June 14, 2007 at 5:38 am
im pretty sure there is some process somewhere out there pulling data from my server at 5am. i dont know how to find out what login this process is using, or what data they are accessing ( before you scold me for being a poor admin, i inherited this system, i didnt create it!). is there anyway i can see what was accessing my server at any given time?
June 14, 2007 at 6:11 am
There are few ways.
1. Start your profiler and trace the activity
2. Audit the server login and logoff
3. write a job to track all the users activity that happens between 4AM till 6 AM.
You said that some might scold for being a poor DBA. Don't worry on a very bad day even the best DBA can get his data out by a good hacker. It all depends on how proactive we are.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 15, 2007 at 12:01 am
you could also create a logon trigger:
http://technet.microsoft.com/en-us/library/bb326598(SQL.90).aspx
---------------------------------------
elsasoft.org
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply