Sql server updating a master database


When I queried the [master].[sys].[master_files] and [user Database].[sys].[database_files] views, I could see where the e-mail was presumably getting its values from.



Hello, I was adding a SQL Agent Alert to check the data file size of a user database and e-mail me if it increased beyond a certain threshold.While setting up this alert, I checked the size of the data file using SSMS (right-clicked the user database and selected Tasks / Shrink / Files) and deliberately set the alert threshold to a value lower than this to test that the alert worked.The alert certainly did its job immediately, however the current value reported in the e-mail was significantly higher than what I was expecting.Having a firm understanding of the SQL Server databases is beneficial when you need to troubleshoot an issue, gather data from SQL Server, etc.

This tip will outline the SQL Server system databases, explain the core objects used in the relational databases and outline some do's and don'ts when working with the system databases.

Is a read-only database that contains system objects that are included with SQL Server.



Sql server updating a master database comments


  • Updating master.sys.master_files and User Database.sys. profil de paulette60

    paulette60

    Hello, I was adding a SQL Agent Alert to check the data file size of a user database and e-mail me if it increased beyond a certain threshold. While setting up this.…
  • System Databases Microsoft Docs profil de paulette60

    paulette60

    SQL Server includes the following system databases. System database Description master Database Records all the system-level information for an instance of.…