July 26, 2006 at 12:21 pm
HI, I have a special situation, some one has droped, deleted, removed my databases (39 db's), in MSSQL\DATA there is not any database file, only master, msdb.
Is there a way to know who did it?, or where Sql Server save this kind of information, I have log explorer tool and I'm looking at my master db but I don't really know where to find this information.
Thanks for any help.
July 27, 2006 at 9:34 am
Have you checked the windows event logs? The security log will show you who connected to the server. It would have to be a sys admin or administrator to drop a database and delete the files, if your server security is set up properly.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply