sp_PurgeMissingDbs
Command - Action
sp_PurgeMissingDbs will delete previously captured database names from the system.
This is useful when a database has been deleted from the server and there is no need to receive Health Findings about the database missing.
Usage:
sp_PurgeMissingDbs
Delete missing databases from the [Databases] table.
Use this to remove alerts for databases that have been deleted on a server.
Technical Details:
- Effect: Delete rows from the [Databases} and [DatabaFiles] tables for databases that are flagged as missing.
- Type: Command - Action
- Schema: dbo
Removing missing databases will prevent Alerts 3003 and 3007 from firing.
Page Last Updated: 26 June 2025