Restore Overview
Appendix C: Backup and Recovery Best Practices 129
Torn Page Repair Dependency Checklist
A Torn Page Restore restores only the pages of data on disk marked as damaged.
SQL Server 2005 and later have the ability to isolate damaged parts of a
database while leaving the rest intact. When this happens with a Full Recovery
Model database, the database may be eligible for a Torn Page repair, which is
much faster than a Database restore. The dependencies for this restore type are
similar to those for a Files and FileGroups restore.
There are both Online and Offline versions of this operation.
■
Online -- The database remains online and undamaged tables are still
accessible. This requires the Enterprise Edition of SQL Server.
■
Offline -- The database should be taken offline using a Log Tail backup before
the restore is performed.
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
Use one of the following:
■
All successive Transaction Log backups
■
All successive Transaction Log backups
with Truncation and Transaction Log Tail
backups