is there a chance of mixing up of data in secondary file?

[smileprince00]

hi friends, i am new learner of this sql server 2008.my question is if my primary data file i.e .mdf is restricted to certain amount of memory like 100mb..i have some more secondary data files.i.e .ndf..
wen ever the memory of .mdf is filled in restricted memory, the control storage will automatically switch on to .ndf files and there the data storage can takes place..
now my question is ...if that shifting of data storage to .ndf from .mdf takes place, dont there be a chance of mixing up of data of different users???

then what is the purpose of creating those .ndf files???

if this arises how can we overcome them........... ............... ..???
please give me correct and clear clarification regarding these issues so that i will be very much thank ful to u.........

regards
rohit maruthi sesha sai.v

[ck9663]

I believe SQL Server is smart enough to figure out who belongs to who in terms of which data goes to which filegroups and who owns it. About the purpose of .ndf files, here's a good read about filegroups.

Happy Coding!!!

--- CK