Computer Associates SQLSTQ99000600 Microsoft SQL Guide - Page 129
Torn Repair Dependency Checklist
UPC - 757943257441
View all Computer Associates SQLSTQ99000600 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 129 highlights
Restore Overview 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 Database Full Backup Prerequisites None For more information, see Note 2 (see page 130). Partial Full Backup None For more information, see Note 2 (see page 130). Files and FileGroups Full Backup None For more information, see Note 2 (see page 130). Database Differential Backup For more information, see Note 1 (see page 130). The last prior Database Full backup 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 Post-requisites Use one of the following: ■ All successive Transaction log backups ■ All successive Transaction Log backups with Truncation and Transaction Log Tail backups Use one of the following: ■ All successive Transaction log backups ■ All successive Transaction Log backups with Truncation and Transaction Log Tail backups Use one of the following: ■ All successive Transaction Log backups ■ All successive Transaction Log backups with Truncation and Transaction Log Tail backups Use one of the following: ■ All successive Transaction Log backups ■ All successive Transaction Log backups with Truncation and Transaction Log Tail backups Use one of the following: ■ All successive Transaction Log backups ■ All successive Transaction Log backups with Truncation and Transaction Log Tail backups Appendix C: Backup and Recovery Best Practices 129