bak'
WITH NORECOVERY, NO TRUNCATE
GO
RESTORE DATABASE AWSample
FILEGROUP='PRIMARY'
FROM DISK='E:\DATA\AWSFGPrimary.bak'
WITH PARTIAL, NORECOVERY
-- Continue to restore any application transaction logs
-- Apply the tail-log backup
RESTORE LOG AWSample
FROM DISK 'E:\BackupData\AWSample_TailLog.bak'
WITH NORECOVERY
-- I prefer to do recovery as a separate step
RESTORE DATABASE AWSample
WITH RECOVERY
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 94
At this point, the PRIMARY filegroup is online, while any remaining filegroups are
offline with restore pending. Any objects contained in PRIMARY are now available for use.
You can restore the remaining filegroups normally, since the PARTIAL clause indicates that
the database is in a piecemeal restore process. Once you??™ve restored all filegroups, SQL
Server resets the PARTIAL flag.
If you??™ve designed the physical and logical structure of the database properly, piecemeal
restores can make the difference between being a hero and losing your job.
Backing Up and Restoring Full-Text Indexes
SQL Server 2005 includes added backup functionality: full-text indexes are associated
with a specific filegroup in every database, as shown in Figure 4-9.
Pages:
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203