Once you create the
filegroups, you can associate new files with a specific filegroup using the Files page
(which you get to from the ???Select a page??? menu on the left), as shown in Figure 4-2.
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 78
Figure 4-2. Associating new files with a filegroup
When adding a file to a filegroup, the Filegroup column shows only filegroups that
you??™ve created already. If you haven??™t saved the database with the new filegroups defined,
they won??™t show up on this screen.
Notice that I??™m using a naming scheme for both the filegroups and the files that indicates
what a given filegroup contains and which filegroup a file belongs to. Examples in
many sources, including BOL, label filegroups with no particular meaning (e.g., FG1 and
FG2). For a relatively simple database, such meaningless naming would suffice. However,
if you have a relatively complicated database design with numerous filegroups and files,
that sort of naming scheme can create a challenging environment to support.
While two physical file names cannot be the same, it is possible to have filegroups
under different databases with the same name.
Pages:
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178