- If they should have autogrowth enabled?
- If they should restrict the size of the file?
Regarding the ‘restrict the size’ of a database file option. I generally leave that set to unrestricted because I monitor and have alerts setup on free disk space so I’m able to work on storage before it becomes an issue and I don’t want my database falling over because I set a limit on the size of the file. I’m sure other people have different views on this and I would be more than interested to know if people do things differently and why, in the comments below.