Deleted Database

Question

Deleted Database

chris.liu

Valued Member

Points: 74
More actions
July 21, 2008 at 3:01 pm

#195867

Is there a way to check who deleted a database?

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90314 More actions · Answer 1

Check the SQL Server logs - should be something in there related to the drop/detach of the affected database.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

chris.liu Valued Member Points: 74 More actions · Answer 2

chris.liu

Valued Member

Points: 74

July 21, 2008 at 3:24 pm

#846037

There is no such information in SQL LOG.

Jeffrey Williams SSC Guru Points: 90314 More actions · Answer 3

If the event happened recently enough, you can try pulling it from the default trace.

Declare @path varchar(100);

Set @path = (select path from sys.traces where id = 1);

Select *

From fn_trace_gettable(@path, default)

Where ObjectType = 16964

And EventClass = 47;

ObjectType = 16964 is the database object

EventClass = 47 is Object:Deleted (supposed to be Object : Deleted - no spaces)

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

chris.liu Valued Member Points: 74 More actions · Answer 4

It does show up some info about deleted dbs. But there is nothing about the database I am looking for and the database is not in the server.

chris.liu Valued Member Points: 74 More actions · Answer 5

It does show up some info about deleted dbs. But there is nothing about the database I am looking for and the database is not in the server.

chris.liu Valued Member Points: 74 More actions · Answer 6

It does show up some info about deleted dbs. But there is nothing about the database I am looking for and the database is not in the server.

Jeffrey Williams SSC Guru Points: 90314 More actions · Answer 7

The only thing I can think of is that the database was deleted far enough back that it no longer shows up in the default trace.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

RBarryYoung SSC Guru Points: 143329 More actions · Answer 8

Please do not cross-post.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

chris.liu Valued Member Points: 74 More actions · Answer 9

I think the database was dettached before it was removed. Does anyone know how to check out this?

free_mascot One Orange Chip Points: 27164 More actions · Answer 10

If db was detached; hope following link might help you:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_Edmo/html/b7b3bafd-e510-4fbd-a8f9-64d921eb7140.htm

Good Luck!!

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."