3. This will open up Scheme Changes History report which will have the details about who deleted the SQL Server Database along with the timestamp when the database was deleted. Refer the below snippet for more information.

Identify who deleted the user database using TSQL script

The SQL Server Default Trace file gives very useful information to a DBA to understand what is happening on the SQL Server Instance. For more information, see
Importance of trace files in SQL Server.

Execute the below query to find the default path of trace file in SQL Server.

How to Load SQL Server Trace File in SQL Server Table

Execute the below script to load the default trace file content in a
temporary table to read the relevant information with respect to who deleted the
user database on the instance of SQL Server. If you don't find the relevant
information in the latest trace file then it is recommended to load the data
from all the available trace files on the server to explore the information.

From the above snippet you could see that the event class 46 represents the
database creation time along with the user who created it and
event class 47
represents the database deletion time along with the user who
deleted the
database.

Conclusion

In this article we have seen how easily one can find out who
deleted the user database in SQL Server with the help of in
built SQL Server Schema Changes History Report.