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.