Delete missing database Event Viewer, I can fins this event logged :


  2016-07-10 11:45:01.83 Logon       Error: 18456, Severity: 14, State: 38. 
  2016-07-10 11:45:01.83 Logon       Login failed for user 'Domain\Username'. Reason: Failed to open the explicitly specified
  database. [CLIENT: ]


So,I ran trace and found the database name,but how can I delete the missing database completely. Attached image.

I cannot find the database name in sp_helpdb or sys.databases.


  Cannot open database "DBTest" requested by the login. The login
  failed.
You don’t need to delete the already missing database.The user is configured to use a none existing or deleted database as a default database for the application. First, use trace and check for which application the user is failed to login, then on the application, change the default database to one of the existing databases. Sadequl’s post  might help you for step by step guide to fix the issue, https://www.mssqltips.com/sqlservertip/2581/sql-server-error-18456-finding-the-missing-databases/