Skip to content

SQL Server Faq

  • Home
  • About
  • Archives
  • Contact
SQL Server Faq

data file

SQL 2012 | SQL Maintenance

SQL Server Datafile maxsize reported incorrectly

Recently we encountered and filed a benign reporting BUG which reports the maxsize of the data file incorrectly. If you create a database & then alter the initial size of the database to be greater than maxsize & then query sys.database_files, sys.master_files, sysaltfiles the maxsize appears to be incorrectly reporting the older value of maxsize….

Read More SQL Server Datafile maxsize reported incorrectlyContinue

SQL Maintenance

Script to monitor Free Space of the data file and send alert

Recently I had to create a script which will monitor free space of all the datafiles and send alert if the free space within a datafile falls below 10% of the Total file space. The following script should help to achieve the objective so sharing with the larger audience SET NOCOUNT ON DECLARE @Tbl Table…

Read More Script to monitor Free Space of the data file and send alertContinue

© 2023 SQL Server Faq

  • Home
  • About
  • Archives
  • Contact