If you replace the missing read-only files, you can simply recover
the database (remember how I prefer to recover the database as a separate step?):
RESTORE DATABASE Adventureworks
WITH RECOVERY
If you have to restore that read-only filegroup separately, you??™ll need to use a different
technique. You??™ll still use the PARTIAL keyword, but you??™ll need to recover the
database and put it online before restoring the read-only filegroup. Such a process is
referred to as a piecemeal restore.
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 93
Performing Piecemeal Restores
With SQL Server 2000, you could do a sort of piecemeal restore, sometimes referred to as
a partial restore. It had limitations, the biggest being that it was an offline operation. I
never had the need to use it. Instead, I restored single filegroups that existed on separate
I/O paths (so chances were only one would fail at any given time).
With SQL Server 2005 Enterprise Edition, you can do online piecemeal restores.
After you restore the PRIMARY filegroup, you can bring individual filegroups online as you
restore them.
Pages:
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201