bak'
WITH NORECOVERY
-- I prefer to do recovery as a separate step
RESTORE DATABASE AWSample
WITH RECOVERY
This example shows a basic filegroup recovery. Sometimes you may want to restore
a single filegroup, but in most cases, you??™ll want to restore the entire database one piece
at a time.
Performing Partial Backups and Restores
Although it does deal with filegroup backups, a partial backup is really more like a full
backup. You perform a partial backup by specifying the keyword READ_WRITE_FILEGROUPS
in your BACKUP DATABASE command:
BACKUP DATABASE Adventureworks
READ_WRITE_FILEGROUPS TO
DISK='C:\AWPartial.bak'
What??™s the point of a partial backup? Well, if you have filegroups that are read-only,
they really only need to be backed up once, don??™t they? Plus, you don??™t really need to use
the BACKUP DATABASE command to back them up??”you could just stop SQL Server at some
point and perform a file-based backup on those read-only files.
Let??™s say you have two tables: an Order table and an OrderHistory table. Order is 80MB
in size, with another 70MB of nonclustered indexes on it.
Pages:
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199