Results 1 to 5 of 5

Thread: how to find who is deleted the database or object?

  1. 08-05-2003, 12:55 PM #1
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231

    how to find who is deleted the database or object?

    Hi,
    I wanted find the log information if anybody deleted my database or bojects in my server.
    Is it possible we can able to find this details in my previous log or any sys tables ?
    Thanks
    Reply With Quote Reply With Quote
  2. 08-05-2003, 12:58 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    SQL Server does not provide this information unless you are running C2 level audit or running trace to capture this info.

    You can use Log Explorer from Lumigent to dig this kind of information from your transaction log.
    Reply With Quote Reply With Quote
  3. 08-05-2003, 03:37 PM #3
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231
    skhanal,
    How we can implement this C2 level audit security.
    Thanks,
    Ravi
    Reply With Quote Reply With Quote
  4. 08-05-2003, 04:06 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    As I know, C2 level audit will slow down the system.
    Reply With Quote Reply With Quote
  5. 08-05-2003, 04:11 PM #5
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    It does slow down the system significantly because everything is logged to a file.

    Check "c2 audit mode Option" topic in books online.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules