Press "Enter" to skip to content

Figuring Out Who Dropped That Database

Kevin Hill reads the default trace to figure out who dropped a database:

We have a staging server that has a database for each client that we can test on before working in their production databases.   Recently one has gone missing a few times…but nobody will own up to it.

If you want to set up an extended event to capture this information to disk separately, Jason Brimhall has you covered.