Files and FileGroups Restore Dependency Checklist-MSSQLSvrWSPW

Backup and Recovery Best Practices › Restore Overview › Checklists for Dependencies, by Type › Files and FileGroups Restore Dependency Checklist-MSSQLSvrWSPW

Files and FileGroups Restore Dependency Checklist-MSSQLSvrWSPW

A Files and FileGroups Restore restores and recovers selected files and FileGroups. You can restore Files and FileGroups from a Files and FileGroups, Partial, or Database backup.

A Files and FileGroups restore, like a Differential or Log restore, can only be applied to either the original database from which it was backed up, or to a copy that has never left the loading or standby state. A Mirror database qualifies as either a standby copy or the original database for this purpose.

Sequence is important when performing a Files and FileGroups restore.

Selected Session	Prerequisites	Post-requisites
Database Full Backup	None For more information, see Note 2.	Use one of the following: All successive Transaction log backups All successive Transaction Log backups with Truncation and Transaction Log Tail backups
Partial Full Backup	None For more information, see Note 2.	Use one of the following: All successive Transaction log backups All successive Transaction Log backups with Truncation and Transaction Log Tail backups
Files and FileGroups Full Backup	None For more information, see Note 2.	Use one of the following: All successive Transaction Log backups All successive Transaction Log backups with Truncation and Transaction Log Tail backups
Database Differential Backup For more information, see Note 1.	The last prior Database Full backup	Use one of the following: All successive Transaction Log backups All successive Transaction Log backups with Truncation and Transaction Log Tail backups
Partial Differential Backup For more information, see Note 1.	Use the more recent of the following: The last prior Database Full backup The last prior Partial Full backup	Use one of the following: All successive Transaction Log backups All successive Transaction Log backups with Truncation and Transaction Log Tail backups
Files and FileGroups Differential Backup For more information, see Note 1.	The last prior Full Backup that contains the files included in the selected session	Use one of the following: All successive Transaction Log backups All successive Transaction Log backups with Truncation and Transaction Log Tail backups

Selected Session

Prerequisites

Post-requisites

Database Full Backup

None

For more information, see Note 2.

Use one of the following:

All successive Transaction log backups
All successive Transaction Log backups with Truncation and Transaction Log Tail backups

Partial Full Backup

None

For more information, see Note 2.

Use one of the following:

All successive Transaction log backups
All successive Transaction Log backups with Truncation and Transaction Log Tail backups

Files and FileGroups Full Backup

None

For more information, see Note 2.

Use one of the following:

All successive Transaction Log backups
All successive Transaction Log backups with Truncation and Transaction Log Tail backups

Database Differential Backup

For more information, see Note 1.

The last prior Database Full backup

Use one of the following:

All successive Transaction Log backups
All successive Transaction Log backups with Truncation and Transaction Log Tail backups

Partial Differential Backup For more information, see Note 1.

Use the more recent of the following:

The last prior Database Full backup
The last prior Partial Full backup

Use one of the following:

All successive Transaction Log backups
All successive Transaction Log backups with Truncation and Transaction Log Tail backups

Files and FileGroups Differential Backup

For more information, see Note 1.

The last prior Full Backup that contains the files included in the selected session

Use one of the following:

All successive Transaction Log backups

All successive Transaction Log backups with Truncation and Transaction Log Tail backups