SQL Database Snapshots

by Jul 25, 2014

I have a user who has created some Database Snapshots of their database, Elements is showing this like it is a database with the errors and alerts that show it hasn’t been backed up and log file is full, etc. When I look in the Databases table in the IderaElementsRepository database, I don’t see a way to tell if this is a database or a snapshot. Can/Should(?) snapshots be excluded from the standard alerts? Is there a way in the raw data to signify that an object is a snapshot and not a normal table?

msdn.microsoft.com/…/ms175158(v=sql.110).aspx