Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

What is the correct approach for handling MS SQL "system" databases?

Bobby Campbell
Mega Sage

Our database owner does not see value in having CIs for the system databases: master, model, msdb, tempdb, mssqlsystemresource.  He has asked us to hide or otherwise eliminate them from the CMDB.

 

We have considered:

  • prevent discovery from creating these CIs, perhaps via a pattern extension
  • create a business rule or data policy to delete or retire them
  • filter our views so that these CIs still exist, but aren't visible to anyone but admins

Has anyone else encountered a similar situation in their environment? If so, how did you handle it?

5 REPLIES 5