Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

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