Summary
I??™ve explored many of the aspects of a restore process, from technical commands to the
potential for errors. You??™ve seen how to restore from full backups and from differential
backups. You??™ve seen how to restore to a specific point in time, how to mirror and stripe
your backups, and much more. You have many options at your disposal when it comes to
restoring a database and getting it back online again.
In the next chapter, I??™ll show you how you can have even more granular control over
your backup and recovery strategy. You??™ll learn to back up and restore only specific files
and filegroups. And if you??™re wondering why you??™d care to do such a thing, you??™ll learn
that, too.
CHAPTER 3 n RESTORING A DATABASE 73
Backing Up and Restoring Files
and Filegroups
The concept of a filegroup has been in place since the introduction of SQL Server 7.0.
Essentially, a filegroup is a construct to provide a logical storage location for an object
when it is created. Thus, you can put different tables and indexes in separate filegroups
to not only improve performance, but more important, to minimize backup and recovery
times.
Pages:
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173