Restore Overview
128 Agent for Microsoft SQL Server Guide
Selected Session
Prerequisites
Post-requisites
Files and FileGroups
Differential Backup
For more information, see
Note 1
(see page 130).
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
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
(see page 130).
The more recent of the following:
■
The last prior Database Full Backup
■
The last prior Partial Full Backup
None
