ASE implements Recovery Fault Isolation (RFI), an online recovery feature that provides a level of granularity in recovery by means of partial recovery. RFI can isolate corruption, encountered during recovery, to the corrupt pages. This enables you to restore database integrity by isolating and repairing corruption on a page by page (and, consequently, on an object by object) basis without having to restore the entire database and transaction logs from backups.
While RFI can only define granularity at the page or
database level, corruption is typically corrected at the object
level with, for example, an entire index being recreated or an entire
table being replaced.
