Table 5-15 lists the system procedures that support recovery fault isolation:
System Procedure |
Description |
---|---|
sp_forceonline_db |
Provides access to all the suspect pages in a database. |
sp_forceonline_page |
Provides access to an individual suspect page. |
sp_listsuspect_db |
Lists all databases that have pages marked suspect by recovery. |
sp_listsuspect_page |
Lists all pages in a database that are marked suspect by recovery. |
sp_setsuspect_granularity |
Displays and sets the recovery fault isolation mode. This mode governs whether recovery marks an entire database or only the corrupt pages suspect. |
sp_setsuspect_threshold |
Sets the maximum number of suspect pages that recovery will allow in a database before marking the entire database suspect. |