Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a secondary (.ndf) file that has grown out of control and filled a disk.

Now when I query the DB settings using select * FROM sys.database_files max_size is -1 (File will grow until the disk is full) but growth is 0 (File is fixed size and will not grow).

Is this expected? Or has someone changed a setting after the fact? These two settings appear to be in conflict with each other - how do they interact?

share|improve this question
Easy to test this. –  Martin Smith Jun 20 '13 at 11:50
add comment

migrated from superuser.com Jun 20 '13 at 10:56

This question came from our site for computer enthusiasts and power users.

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.