Blitz Result: Database Max File Size Set

Running out of disk space sucks, so sometimes we set up max file sizes for a database to make sure it doesn’t run us out of space.  This part of our sp_Blitz® script checks for databases with the maximum file size set to anything other than unlimited.

To Fix the Problem

In SQL Server Management Studio, you can right-click on the database, click Properties, and look at the files.  If you’re okay with a file growing to an unlimited size, change that setting.

Return to sp_Blitz® or Ask Us Questions