shindle 17293 (11/14/2013)

---

I have a db that has 3 data files. The first data file is on one drive and the remaining two on another. All three were set to autogrow with no limit on maxsize.

My understanding is that data is spread evenly across all three data files? So as the database grows data is placed evenly across all three data files and each file would autogrow as required until maxsize is reached. However, I noticed that the third file had not really grown which surprised me? The first two were set to the same initial size but the third was set to a much smaller size - would this have caused that?

Also, should there not be a limit set on the max size of each file to avoid filling a drive, particularly on the drive with two data files?

Thanks

Steve