Results 1 to 3 of 3

Thread: drop database

  1. 03-16-2004, 04:33 PM #1
    ndba
    ndba is offline Registered User
    Join Date
    Sep 2002
    Posts
    78

    drop database

    Hi:

    Someone dropped a database on our server and we are trying to figure out who dun it! I have already looked at the sql error logs and there is nothing in there. I have looked in the Windows 2000 event viewer but nothing in there. Is there somewhere else I should be looking ? What is the best way to prevent this in the future. Please advise.

    Thanks,
    ndba
    Reply With Quote Reply With Quote
  2. 03-16-2004, 04:42 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    How to find who did it?

    mmmmm... difficult. Are you running security audit on that box? then you can find who logged in at that time of deletion.


    How to avoid?

    1. Do not give SA Access to anybody other than you.

    2. enable security auditing

    3. take backups and tanlog backups often so that you can restore immedietly.

    4. do not keep easy passwords like "sa" and "password" or blank.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 03-16-2004, 04:49 PM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    see whether there is any "KILL" command used in the error log. was the database ever been used?
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    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