alert when database was created / dropped
It would be nice to have a build in alert when someone (e.g. a vendor) created or dropped a database.
Reasons:
- you may want to delete old backup files (if dropped) or have to modify / delete some maintenances
- you'll make a manual full backup of the new DB so that log-backups could be taken by your backup solution
- maybe you have to add the new DB to monitoring (as DLM Dashboard), backups (and have to consinder its the disk space at the backup drive) or an Excel-Sheet with a list of your databases :-)
Real-Live-Example:
I received at around 18:45 a log-backup-overdue-alert (should trigger if there were no log backups since 10 minutes). By checking the backup directory at the next morining I figured out that there were no log backups made between 16:00 and 00:45 (so the alert should have been triggered at 16:10). Speaking with the admin for this application I discovered that the DB was dropped at ~16:00 and recreated at ~18:35 (= database creation time in the log-backup-overdue-alert). Because they did not make a manual full backup it could not create log backups until the nightly job made an automatical full backup.
If I had an alert telling me, that someone dropped / created a database, it would have been easier to figure out the "strange" behavior.