July 21, 2008 at 3:01 pm
Is there a way to check who deleted a database?
July 21, 2008 at 3:08 pm
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
July 21, 2008 at 3:24 pm
There is no such information in SQL LOG.
July 21, 2008 at 3:49 pm
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
July 21, 2008 at 3:54 pm
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.
July 21, 2008 at 3:54 pm
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.
July 21, 2008 at 3:54 pm
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.
July 21, 2008 at 3:56 pm
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
July 21, 2008 at 10:44 pm
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]
July 22, 2008 at 7:10 am
I think the database was dettached before it was removed. Does anyone know how to check out this?
July 22, 2008 at 7:19 am
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."
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy