Hi, I just want to double check the procedure for setting max file size on Sharepoint databases (2010). I'm going to go with recommended max file size (200GB Content db - 100GB site collection db), or maybe smaller for improved manageability. Usually i have a .mdf that i restrict to a certain size and create a .ndf that picks up the data when the .mdf is full. I guess it is standard procedure for Sharepoint also but can anybody just verify this? 1. I create .ndf - set max size 100GB 2. I set max size 100GB for the .mdf 3. .ndf takes over when maxsize reached for .mdf Also if I create 2 .ndf files at the same time, which one is chosen to take over? Is there any scenario where some kind of proportional fill is used between .mdf and .ndf or does it fill upp .mdf to maxsize and then proceed to .ndf?
There is an additional abstraction layer in the storage engine that you have not mentioned so far - Database Filegroups. You group database files into a filegroup (you start with just one filegroup called "PRIMARY"). All files in that filegroup are then written to using a proportional fill routine. This means that your design will start proportionally filling the mdf and ndf files from the start.