question

Murali avatar image
Murali asked

how to find who dropped databases in sqlserver 2000

how to find who dropped databases in sqlserver 2000
dbaaudittrace
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Grant Fritchey avatar image
Grant Fritchey answered
Unfortunately SQL Server 2000 doesn't have the Default Trace. But it does have a [Black Box trace][1], but it has to be enabled. If you've enabled it you can probably find out who dropped the database. If it's not enabled, you're out of luck. [1]: http://www.sqlservercentral.com/articles/Administration/blackbox/954/
5 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 avatar image Blackhawk-17 commented ·
Security features... only helpful when they are turned on :)
5 Likes 5 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
@Murali, if the answer helped, when any answer helps on the site, please vote it up by clicking on the little thumb pointing upwards. If you think the answer was the right one for your question, please click on the check box. That's how it's clear that a given answer is the right one for people with the same problem who are reading this later after a google search or something. Thanks.
3 Likes 3 ·
Oleg avatar image Oleg commented ·
Restricting users' permissions so that they cannot drop tables even if they **want to** might help as well :)
1 Like 1 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Unfortunately true. Hopefully good backups were in place.
0 Likes 0 ·
Murali avatar image Murali commented ·
Thank you.
0 Likes 0 ·
basit 1 avatar image
basit 1 answered
it can be possible if you create the DDL Triger on it... it will give you all the history for the DDL transaction that are going on your database ... You can check it from the given below link : http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

gangadharanbalaji avatar image
gangadharanbalaji answered
Or else you can findout the sqlserver error log or event log Regards Balaji.G
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.