While it??™s true
that databases can work well with a single data file and a single log file, it isn??™t true that
this is the optimal configuration. If that were true, there??™d be no reason to use filegroups
at all.
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 84
While we??™re primarily interested in how filegroups play into a backup and restore
strategy, they have other significant advantages, even for a relatively small database. I??™ll
briefly discuss some of the other major benefits to filegroup usage before moving on to
backup and restore implications.
nNote All of the scenarios in this section assume that each filegroup is on a separate I/O path. While there
can be some benefit even when all filegroups are on the same data array, the intent is to be able to leverage
multiple I/O paths. These scenarios also assume that both the transaction log for the database and tempdb
reside on separate I/O paths. Yes, these are perfect-world configurations, but it??™s best to plan for extremes,
then adjust your plan downward to what is reasonable to implement. I??™ll discuss I/O implications at length
in Chapter 10.
Pages:
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186