Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shamas21
Starting Member
2 Posts |
 Posted - 2011-11-05 : 06:24:22
|
| Hi AllIm trying to understand the concept of File Groups.> Please can someone explain why any database would need more than one File Group for their database i.e. the Primary File Group (.mdf) and they would then create secondary File Groups i.e. .ndf's?> If I create secondary filegroups, do they have tables, functions, stored procedures associated with them? what are they used for?Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-05 : 08:39:23
|
| Filegroups are used to separate tables and indexes out onto other drives, for either IO performance or database recoverability.http://msdn.microsoft.com/en-us/library/ms187087.aspxhttp://msdn.microsoft.com/en-us/library/ms179316.aspx--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
File Groups