How to find deleted database?

Question

How to find deleted database?

solomon.jernas

Hall of Fame

Points: 3680
More actions
January 10, 2012 at 4:41 am

#249312

HI,
Someone deleted database in sql server 2005 server, How to find who has deleted, it has recorded in sql log file?
Please help me.
Thanks

Viewing 15 posts - 1 through 15 (of 20 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

It'll be in the default trace, providing the delete wasn't too long ago. The trace files are in the SQL error log directory, you can copy them then open in profiler or use fn_trace_gettable function

p.s. Please post SQL 2005 questions in the SQL 2005 forums in future.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 2

solomon.jernas

Hall of Fame

Points: 3680

January 10, 2012 at 5:09 am

#1431018

I could not understand , pleas give example

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Mr. Holio Hall of Fame Points: 3314 More actions · Answer 4

or just right click on instance/reports/schema changes history

__________________________
Allzu viel ist ungesund...

azdzn SSCarpal Tunnel Points: 4128 More actions · Answer 5

Hi Guys

Thanks for those information.

On my server, default trace is enabled BUT I can't find the .trc file.

In sys.traces, path is always empty.

I Can't find any .trc file in SQL Server error log directory.

As the report uses the default .trc file too, I can't test it !

Any idea ?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Are you sure default trace is enabled? Are there any trace files in the SQL error log directory?

What's the entire output of a query of sys.traces?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 7

i need information from 5 days back, someone users deleted database?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

Did you check the default trace?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

azdzn SSCarpal Tunnel Points: 4128 More actions · Answer 9

Default trace is enabled :

name minimummaximumconfig_valuerun_value

default trace enabled0 1 1 1

I can't find any trc file in error log directory.

sys.traces :

see attachment.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

azdzn, please start a new thread rather than hijacking someone else's

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass