Previous Topic: Files and FileGroups Restore Dependency Checklist-MSSQLSvrWSPWNext Topic: Torn Page Repair Dependency Checklist


Partial Restore Dependency Checklist

A Partial Restore restores and recovers the Primary FileGroup and any other FileGroups you specify in the Restore Options as a new database. The result is a subset of the database. FileGroups that are not restored are marked as offline and are not accessible.

Due to some FileGroups being offline, a database that was created from a Partial Restore may not be eligible for a Database backup. To resolve this condition, either restore the remaining FileGroups to the partially-restored database, or remove them from the database structure using the Microsoft SQL Server Enterprise Manager or Management Studio.

Selected Session

Prerequisites

Post-requisites

Database Full Backup

None

None

Partial Full Backup

None

None

Database Differential Backup

The last prior Database Full Backup

None

Partial Differential Backup

For more information, see Note 1.

The more recent of the following:

  • The last prior Database Full Backup
  • The last prior Partial Full Backup

None