Skip to content

SQL Server Faq

  • Home
  • About
  • Archives
  • Contact
SQL Server Faq

sysaltfiles

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

© 2023 SQL Server Faq

  • Home
  • About
  • Archives
  • Contact