Tracking Deleted Databases...

  • Hi All,

    Someone deleted the Development database in my company.

    Is it possible to find the date it was deleted and by which user.

    I tried using sys.databases but only got the Creation time.

    Thanks,

    Karthick

  • You could try the default trace, but it might have rolled over by now so you might not get the answer.

    Other than that do you have custom auditing in place?

    Do you have daily backups of the master database which you can restore as a user database and query sys.databases for when it last existed?

    Other than that there is nothing else that will give you the information you seek.

Viewing 2 posts - 1 through 1 (of 1 total)

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