Hi Gail, Can you please find out what api is called?

If possible, what is the sequence of actions that happens when you run a drop database command....

Yes gail, you are right...

But I was the one who is a victim of such scenario. But at this situation, I have backups for all the database I have... First...

It is just that I am trying to understand how drop command works. If we know exactly what command is being run to delete those files may be we can...

do you mean like shift+delete command?

Yes I agree, it could be anyone who could have done it. But I feel I am soely responsible for this. I take the blame and its my failure.

Coming to...

No, haven't copied any transaction logs...

At this point, I am most worried about getting the files and once I get the files, next immediate thing would be secure the server strictly...

Yes I agree, its a grave mistake. We recently moved servers and we were in the process of creating backups and its too late now I guess..

I am currently running...

seems like drop command deletes the mdf files too..

I do not see any physical files on the box. So to ensure, what I did was I created a database (testdb)...