enric vives


Hi everyone,

Primary platform is Sql25k running on 64-bit.

We've got the following files for a concrete database: MDF,NDF1,NDF2,NDF3. My wonder is when Sql decides begins to fill the first NDF... When it checks that the MDF is alreay full

When begins to fill the secondary files What does criteria choose

I wonder how will behave the Database Engine component in the aformentioned cases.

Thanks in advance and regards,





Re: MDF and NDF question

Samsudeen B


SQL Server will start using the NDF file as soon as it get added to the File group.It will not wait till the MDF to get filled completly.It starts distributing the Data equally between the available physical files.






Re: MDF and NDF question

enric vives

So that according your reply if I've created from the outset three NDF along with main datafile (MDF) is possible that data

going to NDF before MDF is full.







Re: MDF and NDF question

Samsudeen B

yes you are correct.It will equally starts filling all the three