December 22, 2008 at 11:23 am
We inadvertantly had 6 DB's DROPPED from a non-prod environment. How can I tell who (or what process) dropped them?
SQL Server Log has nothing. Event Viewer has limited info.
Is there a default trace that would capture this or is this an explicit trace event to be activated?
thx in advance
December 22, 2008 at 2:31 pm
DBASkippack (12/22/2008)
We inadvertantly had 6 DB's DROPPED from a non-prod environment. How can I tell who (or what process) dropped them?
If you didn't have some trace running at the time, you can't.
Is there a default trace that would capture this
Not on SQL 2000.
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply