data file – SQL Server Faq

SQL 2012 | SQL Maintenance

SQL Server Datafile maxsize reported incorrectly

March 16, 2016

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….

SQL Maintenance

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

February 16, 2012May 20, 2012

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…