Database configured with 14 extra database files with unique filegroup names

Hi peter_s

Thanks,
It is OK 🙂

Regarding the original post: please don't edit in the future messages which already got an answer. By changing the content after someone already responded to it, you make his response irrelevant, which might seen like a spam for someone that did not followed the entire thread and does not familiar with the history.

>> Are these created for performance gains if they are distributed to separate disk drives? Is that the main reason?

It might be related to performance, to administrative reason, to privileges for different users and more...

How can we know why someone else did what he did in your system?!? To answer this we need the ability to read his mind. You should ask the person who did the action

>> Also why is the first one taking up most of the space?

Again, how can we know without examine your database?!?

Did you know that even two tables with the exact same columns, same index, and same content can be in different size? I recommend you to check this post and this post, which give one example of such case.

Have a great day 🙂