Computer Associates ARCserve Backup for Windows, Manual

Page: 127 / 137

Restore Overview
Appendix C: Backup and Recovery Best Practices 127
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 (see page 130).
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 (see page 130).
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 (see page 130).
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 (see page 130).
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 (see page 130).
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