By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,843 Members | 2,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,843 IT Pros & Developers. It's quick & easy.

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

P: 7
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
Dec 2 '09 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
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
Dec 2 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.