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 |
|
RobVG
Starting Member
42 Posts |
 Posted - 2004-06-14 : 10:39:52
|
Hi All.I'm having a little problem understanding filegroups.  1) Are all .mdf files placed in the primary filegroup / do user defined filegroups contain only .ndf files?2) What is the purpose of multiple file groups- to spread files across a disk array?3) Where can I find a good graphical representation?Thanks |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-06-14 : 11:50:36
|
| 1) .mdf is just an extension, it's up to you.2) To spread objects across (physical) files.3) I am not sure.-------Moo. :) |
 |
|
|
RobVG
Starting Member
42 Posts |
Posted - 2004-06-14 : 12:14:20
|
| Let me rephrase #1:Do all primary database files have to reside in the Primary File group?(Thanks for the reply) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-14 : 12:43:54
|
| Got books online?BOL:[CODE]PRIMARYSpecifies that the associated <filespec> list defines the primary file. The primary filegroup contains all of the database system tables. It also contains all objects not assigned to user filegroups. The first <filespec> entry in the primary filegroup becomes the primary file, which is the file containing the logical start of the database and its system tables. A database can have only one primary file. If PRIMARY is not specified, the first file listed in the CREATE DATABASE statement becomes the primary file.[/CODE]Brett8-) |
|
|
|
|
|
|
Filegroups ?