SQL Database Snapshots

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

Parents
  • Great news. Will you be adding a field or some other way to identify it in the databases table? e.g. a SourceDatabase field like in sys.databases or a custom is_snapshot or other such field? I’d like to exclude these in some of the database centered reports we’ve created.

    thanks!

Reply
  • Great news. Will you be adding a field or some other way to identify it in the databases table? e.g. a SourceDatabase field like in sys.databases or a custom is_snapshot or other such field? I’d like to exclude these in some of the database centered reports we’ve created.

    thanks!

Children
No Data