About restoring from SQL filegroup backups
|Article:HOWTO24037|||||Created: 2010-01-01|||||Updated: 2011-06-15|||||Article URL http://www.symantec.com/docs/HOWTO24037|
The following are conditions for filegroup restores:
All filegroups must be restored to the same point in time. For example, if a table is deleted from a filegroup, you cannot restore that filegroup to a point in time before the table was deleted and then leave it at that time; you must continue restoring the filegroup to the same point in time shared by all existing filegroups.
To be able to restore a filegroup to the same point in time as the other filegroups, run one of the following log backups:
Filegroup restores can be redirected to a different server, but the database file paths cannot be changed. For example, if the filegroup was backed up from G:\SQLDATA then the filegroup must be restored to G:\SQLDATA, regardless of the server the restore is redirected to.
The options Restore all databases to default drive and Restore all database files to the target instance's data location on the Restore Job Properties for SQL dialog box do not apply to filegroup restores. Filegroups must be restored to the same drive letter and path that they were backed up from.
Article URL http://www.symantec.com/docs/HOWTO24037