Database Dropped

Question

Database Dropped

Nita Reddy

SSCarpal Tunnel

Points: 4182
More actions
May 29, 2007 at 1:14 pm

#178851

Someone deleted database how can I find who deleted the database.
We have windows authentication.
I know this information should be stored in system database. Can someone help me please.
Nita

Viewing 5 posts - 1 through 4 (of 4 total)

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

Adam Wilbur SSCertifiable Points: 7001 More actions · Answer 1

Unless you had a trace running, I think you are S.O.L, unless somebody fesses up to it. In the future, don't give anyone access that will allow them to do this if you cannot trust them to be honest if they make a mistake. You on SQL 2000 right, not 2005?

A.J.
DBA with an attitude

SQLBill SSC Guru Points: 51440 More actions · Answer 2

If you have SQL Server security auditting enabled, you can check the error log to see who was logged in at that time. But SQL Server doesn't keep track of that kind of information. Basically, it figures that if you have permission to drop something, then you can drop it and why should it care?

-SQLBill

John Rowan SSC Guru Points: 56440 More actions · Answer 3

It may also be helpful to look for the MDF and LDF files in case the database has just been detached instead of deleted.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Jeff Moden SSC Guru Points: 1004436 More actions · Answer 4

...and, if there hasn't been too much activity, you may be able to recover the MDF and LDF files if they were, in fact, deleted.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)